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

thanks for all the help, the ; in the for statement got me

yours in humility
peter

----- Original Message -----
From: "Beau Lebens" <B.Lebens <email protected>>
To: "'Peter Brown'" <peter <email protected>>; <php-db <email protected>>
Sent: Friday, October 12, 2001 3:19 PM
Subject: RE: [PHP-DB] Multiple INSERT using for() into a MySQL database

> peter, you have a couple ";" in places where you don't want them
>
> for($i=1, $i<12, $i=$i+1) {; <---- remove this one
>
> }; <---- remove this one
>
> try that out :)
>
> /beau
>
> // -----Original Message-----
> // From: Peter Brown [mailto:peter <email protected>]
> // Sent: Friday, 12 October 2001 11:50 AM
> // To: php-db <email protected>
> // Subject: [PHP-DB] 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
> // 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>
> //
>
> --
> 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> 

-- 
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>