Update problem

[almightyegg]

$unjail = mysql_query("UPDATE users WHERE id = '{$mem['id']}' SET jailed='0', jyear='0', jday='0', jailreason='0', jailedby='0'");

No errors, just won't go into the database help!!

[wildteen88]

add an or die clause after mysql_query function like so:

$unjail = mysql_query("UPDATE users WHERE id = '{$mem['id']}' SET jailed='0', jyear='0', jday='0', jailreason='0', jailedby='0'") or die('Error:<br />' . mysql_error());

[almightyegg]

Error:

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 'WHERE id = '1' SET jailed='0', jyear='0', jday='0', jailreason='0', jailedby='0'' at line 1

[wildteen88]

Your WHERE clause should be at the end of the query.

"UPDATE users SET jailed='0', jyear='0', jday='0', jailreason='0', jailedby='0' WHERE id = '{$mem['id']}'"