[SOLVED] MYSQL UPDATE

[JoeyT2007]

Hey, i'm making a forum and am having a little trouble with updating a post.

I have an edit button, it gets the post and puts it into a text box, but once finished editing, it will not update the post! I made it echo the message before updating and its the right thing and it doesn't give any errors.

 

$postid=$_POST['postid'];
$post=$_POST['post'];
mysql_query("UPDATE posts SET post = '$post' WHERE postid = '$postid'") or die("Could not edit post.");

 

Is there anything wrong with the above is it something else in the code?

[mdnghtblue]

"postid" probably shouldn't have quotes around it:

 

mysql_query("UPDATE posts SET post = '$post' WHERE postid = $postid") or die("Could not edit post.");

 

See if that works.

[JoeyT2007]

That seemed to make stuff worse XD

Could not edit post.

[Barand]

Replace "Could not edit post" with something more informative, like "mysql_error()"

[JoeyT2007]

Why? I'm only getting that error when i remove the ' from it, i don't get any error the way i have it.

 

Anyway, i did what you said, and i edited a post and put "Test Post..." in the textarea and the mysql error was:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Post...\r\n WHERE postid=' at line 1

 

Oh, and also, i tried making it remove the post and readd it with the same data but a different message and it failed too. But if i make a new topic or reply it works fine!

[Barand]

Sounds like $postid does not have a value.

[JoeyT2007]

[move]Woohoo! Thanks It was that![/move]