Posted by Jean Pierre Daviau on 12/30/05 00:01

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: before I have a break down
• Prev in forum: smtp and webmail
• Thread view: before I have a break down

[Reply to this message]