RE: [PHP] Generating mysql statement from php return an error :-(

I _believe_ (not totally sure) that mysql_query() can only handle one statement at a time, and if you need to execute multiple, you will need to use more than one mysql_query() statements. It's a bummer => I have all sorts of problems with it. What's up with your return e-mail address? It's a pain in the ass for all mails to you bouncing... Ben -----Original Message----- From: Jacques [mailto:no_mail@nomail.php.net] Sent: Sunday, July 29, 2001 5:47 PM To: php-general@lists.php.net Subject: [PHP] Generating mysql statement from php return an error :-( Hi, I'm using a table in my session to store my variable to generate later my sql statements. Until now... nothing very weird ! But when I want to generate my sql statement. I've got an error after the first line where I put a comma " ; " to make a difference within my statements. this is a portion of my code : $query.="Insert into product (id_quote,item,description,quantity,unit_price,ext_price,lead) values ('$QUOTE_NUMBER' , '".$TABLE_QUOTE_PRODUCT[$y]["item"]."' , '".$TABLE_QUOTE_PRODUCT[$y]["description"]."', '".$TABLE_QUOTE_PRODUCT[$y]["qty"]."' , '".$TABLE_QUOTE_PRODUCT[$y]["unitprice"]."' , '".$TABLE_QUOTE_PRODUCT[$y]["extprice"]."' , '".$TABLE_QUOTE_PRODUCT[$y]["leadtime"]."');\n"; } $result=mysql_query($query); If I have only one line in my sql and I remove the ; it works. but If I add the ; to separate two sql lines.... error ! Any idea how I can resolve this problem ? Regards, Jacques -- 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