Here is one line of my new query:
INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases',
13.42282);

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

Reply via email to