PHP/MySQL problems

TwistedJester

So I have an assignment due at midnight (creating a crude message board with PHP/MySQL), and it's pretty much all done, all it needs it commenting. However I'm trying to implement something for extra credit. Basically, it's a function that allows moderators to edit messages. However, when I go to update the database, it doesn't update it, although mysql_query() returns a true value. Here is my code :

elseif($action == "Submit Edit")
{
	$messageid = $_SESSION['editmessage'];
	$body = $_POST['body'];
	echo "$body and $messageid<br/>";
	$modid = $_SESSION['id'];
	$body = stripslashes(trim($body . " edited by $modid"));
	dbconnect();
	$query = "update Messages set body = '$body' where message_id = '$messsageid'";
	$result = mysql_query($query);
	echo "result = $result<br/>";
	unset($_SESSION['editmessage']);
	unset($_SESSION['edituser']);
}

Janin

Make sure messageid is set correctly - if it's empty, the query would succeed but do nothing.

TwistedJester

The message ID is set correctly in the echo statement.

Seguer

Try and echo your query to see the result the variables have on it, so you can see what is actually being sent to SQL.

Janin

You could also try calling mysql_affected_rows() after the query has been executed, to confirm that the database isn't updating the row. If it is, it's possible you've got some sort of caching issue.

TwistedJester

Ok, mysql_affected_rows is giving me a 0.

Also, I'm not quite following you Seguer.

Janin

He wants you to echo the value of $query after you define it, so we can see exactly what's being executed.

TwistedJester

Ok... when entering the code to do that, I realized that in the query, I had one too many s's in message_id. Wow. I feel really stupid. Thanks a lot for the help though duders.