Re: php - mysql query issue

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@mediaguide.com> 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. >