RE: [PHP] Fw: Multiple INSERT using for() into a MySQL database

the parse error is in your for loop, it should look like this : for($i=1; $i<12; $i=$i+1) { blah ...; } notice the ';' instead of ',' hope it helps! jessie :) -----Original Message----- From: Peter Brown [mailto:peter@outputdsj.com.au] Sent: Thursday, October 11, 2001 9:08 PM To: php-general@lists.php.net Subject: [PHP] Fw: Multiple INSERT using for() into a MySQL database Hi Novice question time. I am attempting to do a multiple INSERT by creating 11 records in a MySQL database using a for() control structure. The code snippet is as follows for($i=1, $i<12, $i=$i+1) { $query2 = "INSERT INTO ausPermissions(permView,permEdit,permAdd,permDelete,userID,modID) VALUES('N','N','N','N','$id','$i')"; $result2 = mysql_query($query2) or die("doh!"); } the $id is already defined and yes the modID is supposed to correspond to the value of $i I keep on getting the ... parse error, expecting `';'' ... error Anyhow, I am a beginner with PHP and was wondering wondering why \this doesnt work. If I'm not doing this the right way any advice etc would be great. Thanks Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net