I probably would'nt even need the date_format option like this then:
SELECT featured_shows.feature_id, featured_shows.event_id, featured_shows.feat_title, calendar_event.id, calendar_event.date_start FROM featured_shows, calendar_event WHERE DATE_FORMAT(calendar_event.date_start, '%Y-%m-%d') >= DATE_FORMAT(now(),'%Y-%m-%d')
If I was to use a join could I just use Date()?
I'm just not sure How I would join those?
You beat me to the post I'll try what you suggest and get back to you.