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 Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *


/*
What is food to one, is to others bitter poison.
-- Titus Lucretius Carus
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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

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 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 br etc in it):

Query failed: INSERT INTO article_keyword VALUES (3, 'earth', 8.94855);
INSERT INTO article_keyword VALUES (3, 'gases', 13.42282);
INSERT INTO article_keyword VALUES (3, 'called', 8.94855);
INSERT INTO article_keyword VALUES (3, 'atmosphere', 17.89709);
INSERT INTO article_keyword VALUES (3, 'allows', 4.47427);
INSERT INTO article_keyword VALUES (3, 'light', 6.71141);
INSERT INTO article_keyword VALUES (3, 'pass', 4.47427);
INSERT INTO article_keyword VALUES (3, 'absorbed', 4.47427);
INSERT INTO article_keyword VALUES (3, 'earth\'s', 8.94855);
INSERT INTO article_keyword VALUES (3, 'and', 26.84564);
INSERT INTO article_keyword VALUES (3, 'converted', 4.47427);
INSERT INTO article_keyword VALUES (3, 'heat', 4.47427);
INSERT INTO article_keyword VALUES (3, 'energy.', 4.47427);
INSERT INTO article_keyword VALUES (3, 'energy', 6.71141);
INSERT INTO article_keyword VALUES (3, 'natural', 4.47427);
INSERT INTO article_keyword VALUES (3, 'greenhouse', 29.08277);
INSERT INTO article_keyword VALUES (3, 'effect', 6.71141);
INSERT INTO article_keyword VALUES (3, 'car', 6.71141);
INSERT INTO article_keyword VALUES (3, 'temperature', 6.71141);
INSERT INTO article_keyword VALUES (3, 'inside', 4.47427);
INSERT INTO article_keyword VALUES (3, '200', 4.47427);
INSERT INTO article_keyword VALUES (3, 'years', 4.47427);
INSERT INTO article_keyword VALUES (3, 'population', 4.47427);
INSERT INTO article_keyword VALUES (3, 'six', 4.47427);
INSERT INTO article_keyword VALUES (3, 'increase', 8.94855);
INSERT INTO article_keyword VALUES (3, 'gas', 4.47427);
INSERT INTO article_keyword VALUES (3, 'carbon', 4.47427);
INSERT INTO article_keyword VALUES (3, 'concentrations', 4.47427);
INSERT INTO article_keyword VALUES (3, 'temperatures', 4.47427);
INSERT INTO article_keyword VALUES (3, 'lower', 6.71141);
INSERT INTO article_keyword VALUES (3, 'causing', 4.47427);
INSERT INTO article_keyword VALUES (3, 'warming', 8.94855);
INSERT INTO article_keyword VALUES (3, 'our', 4.47427);
INSERT INTO article_keyword VALUES (3, '(the', 4.47427);
INSERT INTO article_keyword VALUES (3, 'troposphere)', 4.47427);
INSERT INTO article_keyword VALUES (3, 'climate', 4.47427);
INSERT INTO article_keyword VALUES (3, 'change', 4.47427);
INSERT INTO article_keyword VALUES (3, 'ozone', 4.47427);
brYou have an error in your SQL syntax near ';
INSERT INTO article_keyword VALUES (3, 'gases', 13.42282);
INSERT INTO article' at line 1

why is it so?


--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php