Why not try setting vars to the date values you wish to select and use them in your where clause? You may have something wrong in this complex syntax. Something like: $st_date = today() ?? $end_date = $st_date less 7 days ?? Where rss_feed_date >= $st_date and rss_feed_date <= $end_date btw - why not use table aliases to save on typing and improve readability? ""Ron Piggott"" <ron.piggott@xxxxxxxxxxxxxxxxxx> wrote in message news:82DDACD57AB849159889CB7C6A3FFAAB@xxxxxxxxxxxxxxx `bible_anagrams_rss_feed`.`rss_feed_date` BETWEEN `bible_anagrams_rss_feed`.`rss_feed_date` AND DATE_SUB( `bible_anagrams_rss_feed`.`rss_feed_date` , INTERVAL -1 WEEK ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
