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()); Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
thefollower Posted December 26, 2007 Author Share Posted December 26, 2007 thankyou Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.