Re: php - mysql query issue

From: Date: Fri, 15 Sep 2006 13:09:12 +0000
Subject: Re: php - mysql query issue
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-241821@lists.php.net to get a copy of this message
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.

« previous php.general (#241821) next »