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'? 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'"; 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. 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. 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))"; 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. Link to comment https://forums.phpfreaks.com/topic/205143-multiple-where-responses/#findComment-1074391 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.