[SOLVED] why doesnt my update work

[thefollower]

I have this update which doesn't seem to update my table but also produces no error either =/

 

This is what i got :

 

$Date = date("Y-m-d H:i:s",time());
$NewTotal = 100;
$UpdateMyTravel = "UPDATE countryusercoords SET HitchHike=HitchHike+$NewTotal AND StartedHitchHike='$Date' WHERE UserID= '{$_SESSION['Current_User']}'";
$travelresult = mysql_query($UpdateMyTravel) or die(mysql_error());

 

what did i do wrong?

[toplay]

The "AND" doesn't belong there. I think you meant to have a comma.

 

See update syntax:

 

http://dev.mysql.com/doc/refman/5.0/en/update.html

 

 

Moving post to MySQL help area.