Help me....

[Orionsbelter]

hi i have am making a ordering drop down menu for my online users to fliter out other users but am stuck at the mysql query

 

if($order='admin'){

$staff='admin';}

elseif($order='mod'){

$staff='mod';}

 

i have the staff='$staff' in my query but if the dont want to order anyone how do i make it so $staff equals all staff. so both mods and admin are shown.

[Barand]

something like

<?php 
switch ($staff)
{
case 'admin' :
case 'mod'   :
			$where = "staff = '$staff'" ;
			break;
case 'staff' :
               $where = "staff IN ('mod', 'admin')";
}
$sql = "SELECT name FROM users WHERE $where";
?>