Adding to query

PHP
1

How can i add to my query so it searches for membertype4 and 5?

$result = mysql_db_query($dbname, "SELECT * FROM member WHERE MemberType = ‘5’ order by username asc ") or die (mysql_error());

2

mysql_db_query() is now deprecated.

you should use mysql_query() or [URL=“http://au2.php.net/manual/en/mysqli.query.php”]mysqli_query().

 
 
$query = "SELECT * FROM member WHERE MemberType = '5' [COLOR=red]and[/COLOR] MemberType = '4' order by username asc ";
 
$rs = mysql_query($query,$conn);

but can users have more than 1 member type?

are you sure you don’t really want

 
$query = "SELECT * FROM member WHERE MemberType = '5' [COLOR=red]or[/COLOR] MemberType = '4' order by username asc ";