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' Quote 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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/146729-solved-help/#findComment-770392 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.