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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
