Re: PEAR DB_Table LEFT JOIN Headache
| From: | Mark Wiesemann | Date: | Fri, 16 Dec 2005 08:01:50 +0000 |
| Subject: | Re: PEAR DB_Table LEFT JOIN Headache | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-22271@lists.php.net to get a copy of this message | ||
Hi Jay,
"Jay Callicott" wrote:
> I'm doing a LEFT JOIN with a DB Table select and it's driving me
> crazy. The thing works on my windows machine but hangs when I try to
> access it on the server.
>
> Here's the line that's causing trouble: 'join' => "LEFT JOIN
> mls_image ON Residential.
MLS # = mls_image.MLS_num",
>
[...]
>
> I don't understand why the script would just hang. I can't debug the
> thing because I get no error, it hangs for like 10 seconds then
> quits, so I don't even get a blank page or anything.
I don't have an idea, what's causing the problem. Can you please provide
more parts of your code (the table definition class and the script that
uses it) and contact me directly?
Regards,
Mark