dadamssg Posted February 24, 2009 Share Posted February 24, 2009 so i have events stored in my database with a start and end datetime and an eventtype column. I wanna pull up all events that haven't ended...i've got this but doesn't work SELECT * FROM `test` WHERE end <= CURDATE() AND WHERE event = 'music' Link to comment https://forums.phpfreaks.com/topic/146729-solved-help/ Share on other sites More sharing options...
napurist Posted February 24, 2009 Share Posted February 24, 2009 take out the second WHERE Link to comment https://forums.phpfreaks.com/topic/146729-solved-help/#findComment-770366 Share on other sites More sharing options...
dadamssg Posted February 24, 2009 Author Share Posted February 24, 2009 awesome thanks man Link to comment https://forums.phpfreaks.com/topic/146729-solved-help/#findComment-770392 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.