Looping Insert Into ??

MichaelHe

Hi everyone.

I have a pictures database, where I link to a number that the picture is named.

But I have ex. 15 pictures that are by the same photographer, I have 15 entries in the database where the photographer is the same on all of them and the picture number is from 1 - 15.
This works fine, but it takes a lot of time to insert these 15 entries in PhpMyAdmin since I have to write all the picture info on all the entries.

There for I thought of making an INSERT INTO site, where I write all the info, and how many pics there is, and it will automaticly insert 15 entries with the same picture info.

I have a form like this :

<input type="text" size="4" maxlength="4" name="Num">
<input type="text" size="30" maxlength="30" name="Photographername">
<input type="text" size="50" maxlength="50" name="Addtext">

if($_POST){
$num'= $_POST['Num'];
$photographername'= $_POST['Photographername'];
$addtext'= $_POST['Addtext'];

I then have this INSERT line:

mysql_query ("INSERT INTO Photos (Picturenum, Photographer, Addtext) VALUES ('$num', '$photographername', '$addtext')");

Now I want it to run this insert line 15 times, with $photographername and $addtext being the same and $num raising from 1 to 15.

Is this possible. Maybe with a Foreach command which I'm not so familiar with ??

laserlight

Now I want it to run this insert line 15 times, with $photographername and $addtext being the same and $num raising from 1 to 15.

Sounds like a for loop would be useful.

Still, it looks like you dont have a primary key for your Photos table, or if you do, then you shouldnt be specifying $num explicitly.

MichaelHe

Ofcause a FOR command... I was looking for the word LOOP..
Thanks

fkm

Doesn't the following work?

INSERT INTO table (dield1,field2) VALUES ('blah','bleh') ('foo','bar')

MichaelHe

I made it like this:

if($_POST){
$number= $_POST['Number'];

IF ($number>'0'){
$num='0';
for ($i=1; $i<=$number; $i++){
$num=$num+1;
mysql_query ("INSERT INTO `TourPhotos` (`Picturenum`, `Photographer`, `Addtext`) VALUES ('$num', '$photographer', '$addtext')");
}}

This way I write a photographer name and a text, and in a field called Number, I write how many pictures this photographer has.

Then if I post, and the number is larger than 0, ex 15, it inserts 15 entries in the database with the same photographer and text, but with the numbers from 1-15 in the Picturenum field.

On another site I then call all pictures with Photographer = something.
And makes a link called

Pictures/<?echo $photograhper;?>/<?echo $picturenum;?>.jpg