[SOLVED] Search parameter help

[forumnz]

I have successfully made a search feature for my site. The user may search for a job and choose a region from a dropdown list. The dropdown list has region names with values such as 1, 2, 3 etc.

 

The search feature basically selects * from db where region='$region' AND (blah blah LIKE blah) ORDER BY blah.

 

The problem is, region with value 0 is "All Regions", but when searching with that value, it returns nothing. Also, regions 2 is basically the bigger area that has regions 2,4,5,6,7,8,9 and region 10 has 11,12,13,14,15.

 

So how can I get it to display all jobs LIKE keyword if user searches All Regions (0), and the same with the 2 other main regions (2,10).

 

Hope that makes sense!

 

Thank you,

Sam.