SQL Statement prob

[nawal]

I try to create sql statement for searching result and the field that i provide is FIVE and it using combo box menu. should i make all 120 sql statement or not?
below the sql code:

$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select' GROUP BY district= '$select2' HAVING dun = '$select4'

ORDER BY id ASC",$connect);

while($myrow = mysql_fetch_array($result)) //ERROR HERE

eRROR when i put too many sql statement

the field is:
$select, $select2, $select3, $select 4, and $select5. Help me

[nemonoman]

Your problem is here, I think:
GROUP BY district= '$select2'

You can GROUP BY district
or put
district= '$select2'

in the WHERE clause or the HAVING clause, however