SQL Problem

[nawal]

$result = mysql_query("SELECT * FROM litrasInfo WHERE libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
GROUP BY libCat = '$select'
OR district = '$select2'
OR dun = '$select3'
OR par = '$select4'
OR zone = '$select5'
ORDER BY id ASC",$connect);

I create prog above n when to search the result, only ONE result found eventhough actually it must display more than one.May be the sql statement id wrong??

[planetsim]

Not really specific here, however run the Query within PHPMyAdmin to see what results you get.

Also why do you have so ORs after the GROUP BY? especially being the same also?

[Drakla]

Originally posted by planetsim
o why do you have so ORs after the GROUP BY? especially being the same also?

I was going to ask that, as they're the same as the ones in the WHERE, so will always be true, meaning the GROUP BY clause will group every single result together on '1', so you're never ever going to get more than one result. I can tell this thread is going to be high maintenance, so I'm just going to stand behind the police tape until the ambulance arrives.