note 59516 added to function.mysql-num-rows

my database is platv3, table is USERS, field is STATE which provide different states for member to choose from.... what i would like to make happen is.... i would like to display how many member counts there are for every state....make it simple, would like to grab how many members belongs to a particular state.... how can i do this? any help would really be appreciated. ---- Manual Page -- http://www.php.net/manual/en/function.mysql-num-rows.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+59516 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+59516&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+59516&report=yes Search -- http://master.php.net/manage/user-notes.php