Sending something multiple times.

[nivlaC]

On my script I want to do this:

mysql_query("INSERT INTO pages_temp VALUES ('mult_id'', '$name', '$date' where templateid='$the_stupid_id', $connect)";

So instead of putting the query 3 or even 5 times, can I do a for loop, and if so, how do I do it?

Thanks.

[GSHelpBoy]

I don't think you can add a WHERE clause to an INSERT statement...

You could use UPDATE, though.

I'm not entirely sure what you are trying to do.

[jshea]

I think GS is right about the WHERE clause.

you could do this if your limit was 5:

$count=0;
while ($count<5){
mysql_query("INSERT INTO pages_temp VALUES ('mult_id'', '$name', '$date' where templateid='$the_stupid_id', $connect)";
$count++;
}

you'd be inserting the same data 5 times though

[nivlaC]

Thanks.

I made a typo with the INSERT INTO. lol

It should have been UPDATE, yes. 🙂