I am writing this in PHP and wondering about my query

[aeroswat]

I need a query that uses an AND and multiple OR's. Basically the results have to have be unfilled orders that are either audio orders, electronic text orders, or large print orders. So the logic would be like this but i'm not sure if this is the correct way to write it.

 

SELECT * FROM table WHERE filled=0 and (type='audio' OR type='electronic' OR type='large print')

 

This is the code i'm using to produce the qry

 

	$resp = explode(";",$res['responsibilities']);

$qry = "SELECT * FROM tblOrders WHERE filled=0 AND (FormatNeeded='";

for($i=0; $i<count($resp); $i++) {
	$qry .= $resp[$i] . "'";
	if($i != (count($resp)-1)) {
		$qry .= "OR FormatNeeded='";
	}
}
$qry .= ")";
$result = mysql_query($qry);

[JREAM]

I think you above would work, but I think the correct way is to do it like this:

 

SELECT * 
FROM table 
WHERE filled=0 
AND
type IN ('audio', 'electronic', 'large print')

 

[aeroswat]

I think you above would work, but I think the correct way is to do it like this:

 

SELECT * 
FROM table 
WHERE filled=0 
AND
type IN ('audio', 'electronic', 'large print')

 

Nice. Didn't know about that. Thank you very much.