[TECK]

ok.. i tried this:

PHP Code:

$usergroups=$DB_site->query("SELECT usergroup.usergroupid,usergroup.title
                             FROM usergroup
                             LEFT JOIN user ON user.usergroupid=usergroup.usergroupid");

while ($usergroup=$DB_site->fetch_array($usergroups)) {
  echo "$usergroup[title]";
} 


it does echo all the usergroups.. why it would not work on your code? it doesnt make sense.. and what's up with all this [high]Cross dependency found in OUTER JOIN[/high]?? i searched php.net and didnt find any relevant help. can you explain firefly? i want to learn this stuff.

thanks alot.