[Palmer ofShinra]

$subber=$DB_site->query_first("SELECT username,userid,usergroupid FROM user WHERE userid=$userid");
echo "$subber[username], your user id is $subber[userid] and your User Group ID is $subber[usergroupid]. Isn't that nifty?";

username,userid,usergroupid is where you choose the fields you want.

Just add the fields you want to select seperated by commas (and no spaces).

The returned array will have matching elements based on that, as my example shows.

Note this will always return an array, even if you're only selecting username.

You have to call the script properly too...

.com/forum/subber.php?action=home&userid=$bbuserinfo[userid]

If you don't pass userid= in the URL, your script will have an undefined variable, which is bad.