Re: [PHP-DB] Error is SQL(works in phpMyAdmin)

2002-07-28 Thread Jason Wong
On Sunday 28 July 2002 15:24, JJ Harrison\\ wrote: > In the mysql command line ; is used to signify the ending of the current > query Yes, but executing MySQL queries through PHP requires that you leave out the ';' -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Softwa

Re: [PHP-DB] Error is SQL(works in phpMyAdmin)

2002-07-27 Thread JJ Harrison\\
In the mysql command line ; is used to signify the ending of the current query "Jj Harrison" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > It turns out phpMyAdmin actually splits up the queries and does them > singaly. > > > -- > JJ Harrison > [EMAIL PROTECTED

Re: [PHP-DB] Error is SQL(works in phpMyAdmin)

2002-07-27 Thread JJ Harrison
It turns out phpMyAdmin actually splits up the queries and does them singaly. -- JJ Harrison [EMAIL PROTECTED] www.tececo.com "Cornelia Boenigk" <[EMAIL PROTECTED]> wrote in message 00ef01c23580$2ed210c0$7f54fea9@zwerg98">news:00ef01c23580$2ed210c0$7f54fea9@zwerg98... > Hi > > > You have an err

Re: [PHP-DB] Error is SQL(works in phpMyAdmin)

2002-07-27 Thread Cornelia Boenigk
Hi > You have an error in your SQL syntax near '; ^ As far as I know MySQL doesn't require a trailing *;* at the end of the query. Regards Conni -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Error is SQL(works in phpMyAdmin)

2002-07-26 Thread JJ Harrison
I do my SQL in phpMyAdmin or at the command line and it works fine. When I try and do my query through PHP I get this(Source to show there are no etc in it): Query failed: INSERT INTO article_keyword VALUES (3, 'earth', 8.94855); INSERT INTO article_keyword VALUES (3, 'gases', 13.42282); INSERT