Posted by Connector5 on 12/30/05 00:23

Get rid of the comma before the word "WHERE"


"Jean Pierre Daviau" <Once@WasEno.ugh> wrote in message
news:r1Zsf.11373$vT1.383504@wagner.videotron.net...
> Hi to everyone,
>
>
>
> Somebody can help me on this?
>
>
>
> here is what the html page shows:
>
> There was a database error when executing <PRE>UPDATE stories SET
> writer='JPD' , page = 'news', headline = 'Test', story_text = 'Na Na',
> picture = 'pictures/one.jpg', modified = '1135893089', WHERE id = '7'
> </PRE>Syntax error near 'WHERE id = '7'' at line 1
> ------I went in my SQL with no more information
>
> UPDATE stories SET writer = 'JPD',
> page = 'news',
> headline = 'Test',
> story_text = 'Na Na ',
> picture = 'pictures/one.jpg',
> modified = '1135893089',
> WHERE id = '7'
>
> #1064 - Syntax error near 'WHERE id = '7'' ?at line 1
>
> ------
>
> here is my php:
> $sql = "UPDATE stories SET writer='$auth_user' , page = '$page',
headline
> = '$headline', story_text = '$story_text', picture = '$filename',
modified
> = '$time', WHERE id = '$story' ";
>
> --
> Jean Pierre Daviau
> --
> phpMyAdmin 2.6.1 MySQL 4.1.9-max
>
> Easyphp1.8
> Apache1.3.24
> DEVC++, borland 5.5
> windows Xp
> asus p4 s533/333/133
> Intel(R) Celeron (R) CPU 2.00 GHz
> http://www.jeanpierredaviau.com
>
>

• Next in forum: Re: smtp and webmail
• Prev in forum: before I have a break down
• Thread view: Re: before I have a break down

[Reply to this message]