What's wrong....

[Kyomu]

What's wrong with the following SQL query?


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



I get the error:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



My brains are fired... help... =(

[Chen]

You are JOINing the forum table to itself without giving them an alias. That's the error, but in your code LEFT JOIN forum should be LEFT JOIN forumpermission.

[Kyomu]

Originally posted by FireFly
You are JOINing the forum table to itself without giving them an alias. That's the error, but in your code LEFT JOIN forum should be LEFT JOIN forumpermission.

Ah, thanks, it works now.
Now I'm getting a parse error here....



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Thanks for the help again.

[Mark Hensler]

$threads=$DB_site->

[Kyomu]

Originally posted by Mark Hensler
$threads=$DB_site->

Ahh, no wonder I couldn't pick it up... too used to C++...

Thanks.