Here is one line of my new query: INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases', 13.42282);
Advertising
I get the same error: You have an error in your SQL syntax near '; INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases', 13.42282)' at line 1 -- JJ Harrison [EMAIL PROTECTED] www.tececo.com ----- Original Message ----- From: "Joni Järvinen" <[EMAIL PROTECTED]> To: "JJ Harrison" <[EMAIL PROTECTED]> Sent: Saturday, July 27, 2002 3:26 PM Subject: Re: [PHP-DB] Error is SQL(works in phpMyAdmin) > Hi. > > The correct way is: > > INSERT INTO table VALUES (to what colums) 'data'; > > Try reading PHP manual from mysql_query and from mySQL manual the INSERT > statements format. > > HTH. > > -Joni > > ----- Original Message ----- > From: "JJ Harrison" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Saturday, July 27, 2002 6:07 AM > Subject: [PHP-DB] Error is SQL(works in phpMyAdmin) > > > > 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 > > [EMAIL PROTECTED] > > www.tececo.com > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
