Multiple INSERT using for() into a MySQL database

From: Date: Fri, 12 Oct 2001 03:50:21 +0000
Subject: Multiple INSERT using for() into a MySQL database
Groups: php.db 
Request: Send a blank email to php-db+get-13280@lists.php.net to get a copy of this message
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 ausPermisions(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

« previous php.db (#13280) next »