Error is SQL(works in phpMyAdmin)
| From: | JJ Harrison | Date: | Sat, 27 Jul 2002 03:07:13 +0000 |
| Subject: | Error is SQL(works in phpMyAdmin) | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20830@lists.php.net to get a copy of this message | ||
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);
<br>You 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
webmaster@tececo.com
www.tececo.com