![]() |
What's wrong....
What's wrong with the following SQL query?
Code:
SELECT forum.*, forumpermission.canpost, forumpermission.canview Code:
Not unique table/alias: 'forum' |
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.
|
Quote:
Now I'm getting a parse error here.... Code:
$threads=DB_site->query("SELECT threadid,forumid,dateline FROM thread WHERE $forumids ORDER BY dateline DESC"); |
$threads=$DB_site->
|
Quote:
Thanks. |
All times are GMT. The time now is 01:36 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|