Xtremer360 Posted June 18, 2010 Share Posted June 18, 2010 $query = "SELECT * FROM `efed_list_shownames` WHERE `type` = 'singular'"; How do I add something at the end of the type to where it can be 'singular' and 'recurring'? Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/ Share on other sites More sharing options...
Mchl Posted June 18, 2010 Share Posted June 18, 2010 $query = "SELECT * FROM `efed_list_shownames` WHERE `type` = 'singular' OR type = 'recurring'"; Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1073792 Share on other sites More sharing options...
Xtremer360 Posted June 18, 2010 Author Share Posted June 18, 2010 Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1073995 Share on other sites More sharing options...
Xtremer360 Posted June 19, 2010 Author Share Posted June 19, 2010 I want to add one thing to the where cause that in addition to it having a type of either recurring or singular it also needs to have the ecb.status_id to be equal to 4 or 5. I tried a few different things and it didn't work. Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1074274 Share on other sites More sharing options...
Mchl Posted June 19, 2010 Share Posted June 19, 2010 $query = "SELECT * FROM `efed_list_shownames` WHERE (`type` = 'singular' OR type = 'recurring') AND (ecb.status_id IN (4,5))"; Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1074313 Share on other sites More sharing options...
Xtremer360 Posted June 19, 2010 Author Share Posted June 19, 2010 Thank you. Quote Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1074391 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.