[SOLVED] mysql_query

[chriscloyd]

Can you get a mysql where u do it like this "WHERE level = 'sales', 'admin'
heres my code
[code]
<?
$sales = mysql_query("SELECT * FROM users WHERE level = 'sales', 'admin' ORDER BY first ASC");
while ($s = mysql_fetch_assoc($sales)) {
      echo '<option value="'.$s['id'].'">'.$s['first'].' '.$s['last'].'</option>';
}
?>[/code]

[.josh]

select * from users where level in ('sales','admin') order by first asc

[chriscloyd]

if i want to order by frist name then last name how would i do that?

[artacus]

ORDER BY first, last