DrTrans Posted January 25, 2012 Share Posted January 25, 2012 Query whats wrong with this query? $queryreg = mysql_query("UPDATE application SET employer = '$employer' AND eaddy = '$employer_address' AND ecity = '$employer_city' AND estate = '$employer_state' and ezip = '$employer_zip' AND supervisor = '$employer_supervisor' WHERE appID = '$appID'") or die(mysql_error()); I can't figure it out. Quote Link to comment https://forums.phpfreaks.com/topic/255791-mysql-query/ Share on other sites More sharing options...
scootstah Posted January 25, 2012 Share Posted January 25, 2012 Replace all the AND's with commas. Quote Link to comment https://forums.phpfreaks.com/topic/255791-mysql-query/#findComment-1311225 Share on other sites More sharing options...
AyKay47 Posted January 25, 2012 Share Posted January 25, 2012 refer to the link for correct UPDATE syntax http://dev.mysql.com/doc/refman/5.0/en/update.html Quote Link to comment https://forums.phpfreaks.com/topic/255791-mysql-query/#findComment-1311228 Share on other sites More sharing options...
DrTrans Posted January 25, 2012 Author Share Posted January 25, 2012 Thanks Scootstah!. Quote Link to comment https://forums.phpfreaks.com/topic/255791-mysql-query/#findComment-1311229 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.