FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » PHP discussions » MYSQL Update error
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
MYSQL Update error [message #29793] Mon, 16 January 2006 09:57 Go to next message
saikiran is currently offline  saikiran   India
Messages: 1
Registered: January 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: MYSQL Update error [message #29817 is a reply to message #29793] Tue, 17 January 2006 14:35 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You are missing an = after article_id

FUDforum Core Developer
Re: MYSQL Update error [message #34255 is a reply to message #29793] Mon, 16 October 2006 08:32 Go to previous message
sBForum is currently offline  sBForum   Jordan
Messages: 5
Registered: October 2006
Location: Jordan
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: PHP/SQL help needed....
Next Topic: cookies or sessions???
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 11 23:22:04 EST 2017

Total time taken to generate the page: 0.00736 seconds