I also tried taking the variables out and using this code in the recordsets:
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')
on one and
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')
on the other then I get no errors but the where statement is'nt working I am attaching the page as it now sits. and here is a link to view what it's doing live:
FeaturedExhibits.php
Thanks!
Tracy