The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
1 more left join problem :(
ok i tried to run this query
[SQL] $teamusers = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user LEFT JOIN " . TABLE_PREFIX . "session ON(session.userid = user.userid) WHERE user.teamid='$teamid' "); [/SQL] this query should get all users which in $teamid and their online status now query works fine but if userid show up few times in sessions then its show up the user few times but i want it to show each user only 1 time what am i doing worng ? thanx for help |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|