Multiple INSERT using for() into a MySQL database
| From: | Peter Brown | 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