[SOLVED] mysql error im tottally baffeled here :S

[jamesxg1]

if (isset($_POST['Update'])) {
$whoto = mysql_real_escape_string(stripslashes($_POST['whoto']));

$date = mysql_real_escape_string(stripslashes($_POST['fromdate']));

$date = date('Y-m-d',strtotime("$date"));

$sql = sprintf("UPDATE `unlock` SET whoto = '$whoto', when = '$date'") or die(mysql_error());
$query = mysql_query($sql) or die(mysql_error());

print 'Image Sucessfully Updated.';
}

 

 

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 'when = '2009-04-19'' at line 1

[kenrbnsn]

It's not 'when' it's 'where'

 

Ken

[mrMarcus]

you're using sprintf() incorrectly.

 

if (isset($_POST['Update']))
{
$whoto = mysql_real_escape_string(stripslashes($_POST['whoto']));
$date = mysql_real_escape_string(stripslashes($_POST['fromdate']));
$date = date('Y-m-d',strtotime($date));

$sql = sprintf("UPDATE `unlock` SET whoto='%s', when='%s'", $whoto, $date);
$query = mysql_query($sql) or die(mysql_error());

print 'Image Sucessfully Updated.';
}
else
{ echo "Update button not pushed / set."; }

[soak]

when is a reserved word (http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html) so you need to enclose it in special quotes (sorry, I don't know the name of them but they're at the top left of my keyboard. Like:

 

`when` = '$date'"