AND + OR in one statement

[Kudose]

$listquery = "select * from users WHERE hometown='$hometown' AND type='dj' OR type='promoter'";

How would I make this a valid query?

I need it to search WHERE hometown and hometown tyoe has to be either dj or promoter

[marque]

$listquery = "select * from users WHERE hometown='$hometown' AND (type='dj' OR type='promoter')";

putting brackets in the or statement should fix it

your statement was checking for hometown being equal to $hometown and type being equal to dj. It would have been ignoring type='promoter'

[Kudose]

$listquery = "select * from users WHERE hometown='$hometown' AND (type='dj' OR type='promoter')";  

						$listresult = mysql_query($listquery); 
						while ($row = mysql_fetch_assoc($listresult)) { 

Gives me this:

Warning: Supplied argument is not a valid MySQL result resource in /users/ionichost.com/kcnites/showbyloc.php on line 28

Any ideas? WHILE is line 28. THANKS!

[Kudose]

Thanks for you help, but I got it.