7
le="color: #000000"><?php $member_handler =& xoops_gethandler('member'); $criteria = new CriteriaCompo(); $criteria->add(new Criteria('level', 1, '>=')); $total_users = $member_handler->getUserCount($criteria); echo "Total registered users: $total_users"; echo '<br />'; $criteria->add(new Criteria('user_from', 'RI', '=')); $ri_users = $member_handler->getUserCount($criteria); echo "Users whose location == 'RI': $ri_users"; echo '<br />'; $outofstate_users = $total_users - $ri_users; echo "Out of state users: $outofstate_users";
The user_from condition above does an exact check for "RI". If you want to make it looser, you could use:
$criteria->add(new Criteria('user_from', '%RI%', 'LIKE'));
