thefollower Posted December 26, 2007 Share Posted December 26, 2007 I have a query that even when it runs it still inputs 0 when it shouldn't...i been trying to work it out all day but i cannot see the problem.. no error occurs by the way. $CityID = 1; $Insert = mysql_query("UPDATE userregistration SET CityID='$CityID' AND CityBorn='$CityID' WHERE UserID='{$_SESSION['Current_User']}'") or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/83265-solved-query-insert-wont-work/ Share on other sites More sharing options...
revraz Posted December 26, 2007 Share Posted December 26, 2007 You don't use AND with SET, you use a comma. Link to comment https://forums.phpfreaks.com/topic/83265-solved-query-insert-wont-work/#findComment-423574 Share on other sites More sharing options...
thefollower Posted December 26, 2007 Author Share Posted December 26, 2007 thankyou Link to comment https://forums.phpfreaks.com/topic/83265-solved-query-insert-wont-work/#findComment-423575 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.