The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
what's wrong with this mysql query?
SELECT announcement.title, announcement.userid, announcement.startdate, announcement.pagetext, user2.username as username FROM announcement LEFT JOIN user AS user2 ON (user.userid = announcement.userid) ORDER BY startdate, endate LIMIT 5
I'm getting an error (#1109). |
#2
|
||||
|
||||
Change user.userid to user2.userid in the JOIN.
|
#3
|
|||
|
|||
wow. now that's service. thanks!
|
#4
|
||||
|
||||
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|