[Resolved] Sql Error

[fean0r]

$sql = "UPDATE cs SET
Level='$teamlevel'
    WHERE userid='$userref'";
if ($result = mysql_query($sql)) {
echo "Userlevel Updated to <b>$teamlevel</b>. ";
}
else {
    die(mysql_error());
}

With the above code I'm getting the below error, yet I use this code in other places without error? I've been stumped over it for 2 hours - I cant find any problems 🙁

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 'update='28/07/2004 - 21:33', aupdate='20040728213332', uniqueid

Any help is appreciated, thanks.

[devinemke]

change to:

$sql = "UPDATE cs SET Level = '$teamlevel' WHERE userid = '$userref'";
$result = mysql_query($sql);
if ($result) {echo "Userlevel Updated to <b>$teamlevel</b>.";}
else {die(mysql_error());}

[fean0r]

Sorry I posted the wrong code earlier but they are both the same except this one has 3 updates, I changed the code to match yours but I'm still getting the same error.

$sql = "UPDATE cs SET update='$update', aupdate='$aupdate', uniqueid='$uid' WHERE userid='$userref'";
$result = mysql_query($sql);
if ($result) { echo "ID Updated to <b>$uid</b>.<BR>"; }
else { die(mysql_error()); }

[devinemke]

echo out your SQL before feeding it to mysql_query()

$sql = "UPDATE cs SET update='$update', aupdate='$aupdate', uniqueid='$uid' WHERE userid='$userref'"; 
echo $sql;

what do you see? what is the data structure of the "cs" table?

[fean0r]

UPDATE cs SET update='28/07/2004 - 22:38', aupdate='20040728223843', uniqueid='Nullh' WHERE userid='19'

Thats what I get

[fean0r]

userid - Int
teamid - Int
level - varchar(50)
date - varchar(50)
update - varchar(50)
aupdate - varchar(50)
uniqueid - varchar(50)

[devinemke]

"update" is a reserved word in mySQL and cannot be used for field names.

as a side note: it appears that you are storing date/times and timestamps in varchar fields. why? mySQL has specific field type for these.

[fean0r]

Thanks problem sorted, not using prop num fields is just a bad habit 🙁

Cheers.