FUDforum: PHP discussions » MYSQL Update error

Home » General » PHP discussions » MYSQL Update error

Show: Today's Messages :: Polls :: Message Navigator

MYSQL Update error [message #29793]

Mon, 16 January 2006 14:57

saikiran

Messages: 1
Registered: January 2006

Karma: 0

Junior Member

hi,

I'm getting an error while executing this code in PHP/MySQL

the error no is 1064.

I'm not able to figure out the error in it. Could anyone help me out in this regard

mysql_query("UPDATE articles SET article_title=".$_POST['t1']."where article_id".$_POST['ar']) or die(mysql_error().mysql_errno());// WHERE article_id =$a_id") or die(mysql_error().mysql_errno());

I'm uploaded the file for ur consideration.

thanks and regards
saikiran

Attachment: error_file.php
(Size: 2.16KB, Downloaded 1312 times)

Report message to a moderator

Re: MYSQL Update error [message #29817 is a reply to message #29793]

Tue, 17 January 2006 19:35

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You are missing an = after article_id

FUDforum Core Developer

Report message to a moderator

Re: MYSQL Update error [message #34255 is a reply to message #29793]

Mon, 16 October 2006 12:32

sBForum

Messages: 5
Registered: October 2006
Location: Jordan

Karma: 0

Junior Member

i think it has some problems .. u can try this instead of the one u've written down :

mysql_query("UPDATE articles SET article_title='". $_POST['t1'] ."' where article_id='".$_POST['ar'] ."') or die(mysql_error().mysql_errno());

regards,
sBForum

Report message to a moderator

Previous Topic:	PHP/SQL help needed....
Next Topic:	cookies or sessions???

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 18:01:57 GMT 2024

Total time taken to generate the page: 0.02892 seconds