Han wrote:
Hmm,
still no luck. Thanks for the help. I think I'll have to break the
you mean that it still times out? crashes mysql? maybe the table (tc_countries) is corrupt? try doing a repair.
select up into 2 selects and throw the results of the first into arrays.
Didn't want to do it like that, but it's gonna be quicker now.
if at first you don't succeed... hack ;-)
<snip>
try removing the ORDER BY Clause:
SELECT b.fldName, b.fldEmail, b.fldCountryCode, d.fldCode as FCode, b.fldMobile, a.fldTime as Time, c.fldUsername FROM tblSubscribersChoices a LEFT JOIN tblUser c ON c.fldClientID = a.fldChoice LEFT JOIN tblSubscribers b ON b.fldID = a.fldClientID LEFT JOIN tc_countries d ON d.fldCode = b.fldCountryCode ORDER BY c.fldUsername ASC
OR....
SELECT b.fldName, b.fldEmail, b.fldCountryCode, d.fldCode as FCode, b.fldMobile, a.fldTime as Time, c.fldUsername as Username FROM tblSubscribersChoices a LEFT JOIN tblUser c ON c.fldClientID = a.fldChoice LEFT JOIN tblSubscribers b ON b.fldID = a.fldClientID LEFT JOIN tc_countries d ON d.fldCode = b.fldCountryCode ORDER BY Username ASC
and if that works but doesn't give you repeat records try adding the DISTINCT keyword after SELECT.
<snip>
Why are you so intrested in LEFT JOIN? I cn't help much since i don't know the schema of the db and i can't see clear the meaning of the tables in the query.
Anyway try this:
<SQL>
SELECT b.fldName,
b.fldEmail,
b.fldCountryCode,
d.fldCode as FCode,
b.fldMobile,
a.fldTime as Time,
c.fldUsername as Username
FROM tblSubscribersChoices a, tblUser c, tblSubscribers b,
tc_countries d
WHERE c.fldClientID = a.fldChoice AND b.fldID = a.fldClientID AND
d.fldCode = b.fldCountryCode
ORDER BY Username ASC
</SQL>
Bye
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
