$result = $db->unbuffered_query("SELECT userid, username, birthday, useronlinegroupid, g.useronlinemarking FROM bb".$n."_users LEFT JOIN bb".$n."_groups gs ON (gs.groupid= useronlinegroupid) LEFT JOIN bb".$n."_groups g ON (g.groupid= useronlinegroupid) WHERE ".$query." ORDER BY username ASC"); |