[RESOLVED] query help

[msnhockey]

hey all,

here is my query to my database

$result_pi = mysql_query("SELECT * FROM players WHERE teamid = '".$gm_team2."' AND position != 'G' and status = 'Healthy' AND registered = '1' ORDER BY lname");

this works fine, but i am trying to add in as well status = 'Rookie'

When i try and add this, both the status things work against each other. How can I get this query to bring up both of them.

thanks

mC

[laserlight]

Perhaps try: (status='Healthy' OR status='Rookie')

[msnhockey]

hey bud,

thanks for the info.. now that i see how you did it taht is right for sure... i did this sort of thing once before and couldn't remember at at all.

thanks