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 <[EMAIL PROTECTED]> 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
