[PHP-DB] Multiple INSERT using for() into a MySQL database From: Peter Brown (peter <email protected>)
Date: 10/11/01

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 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>