Lamez Posted December 17, 2008 Share Posted December 17, 2008 is it possible to have two where clauses in a update query? $query = "UPDATE `foot_picks` SET `bowl_name` = '".$name."', `team` = '".$team."' WHERE `user` = '".$username."' AND WHERE `bowl_name` = '".$name."'"; Quote Link to comment https://forums.phpfreaks.com/topic/137311-solved-two-where-clause/ Share on other sites More sharing options...
genericnumber1 Posted December 17, 2008 Share Posted December 17, 2008 Yes, but you only say WHERE once WHERE something = 'something' AND somethingelse = 'somethingelse' Quote Link to comment https://forums.phpfreaks.com/topic/137311-solved-two-where-clause/#findComment-717439 Share on other sites More sharing options...
Lamez Posted December 17, 2008 Author Share Posted December 17, 2008 awesome-tastic! Quote Link to comment https://forums.phpfreaks.com/topic/137311-solved-two-where-clause/#findComment-717443 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.