Also you should check if dates.date is a DATE type, not DATETIME. Lost some time on that when I wanted to select enregs for a specific date, field was DATETIME and I was querying `date` = '2006-01-01'... :p Andy Dave Goodchild wrote: > On 15/09/06, Brad Bonkoski <bbonkoski@xxxxxxxxxxxxxx> wrote: >> >> Have you tried echoing out your query to run on the backend itself? >> Maybe there is some problem with how your join is being constructed... >> Perhaps a left outer join is called for? Hard to tell without having >> knowledge of your table structure and table data... >> >> Yep, I've echoed it and it says: > > "...WHERE dates.date = '2006-10-03'..." > > I think you're right on the join stakes, I will investigate further, many > thanks and have a great weekend. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
