[squawell]

Originally posted by FireFly

No, you didn't.

yes i'm sure!!

see my code

PHP Code:

$users=$DB_site->query("SELECT *
                          FROM user,userfield
                          LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
                          WHERE $condition AND
                                user.userid = userfield.userid
                                ".iif($memberAllGood, " AND user.usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction
                          LIMIT ".($limitlower-1).",$perpage"); 


it should be like this isn't it??

but it still cann't work~~