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. 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. 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 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!. Link to comment https://forums.phpfreaks.com/topic/255791-mysql-query/#findComment-1311229 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.