mysql where

[ngreenwood6]

Is there any way to do two where's in a mysql query? I am talking about something like this:

 

$query = "SELECT * FROM work WHERE tech_id = '$tech_id', completed = 'no';

 

Can someone please help!

[premiso]

$query = "SELECT * FROM work WHERE tech_id = '$tech_id' AND completed = 'no';

 

Use AND

[Adam]

You can also use 'OR' :

 

$query = "SELECT * FROM work WHERE tech_id = '$tech_id' OR completed = 'no';

 

... Except in this case "AND" would seem like the right choice!