help with php and sql

[JuicyScript]

Am trying to build an advance search where by a user can select the following

catergory
-doctors
-nurse

Year
sex
region

I would to display the details a such

doctors -------------------------
|doctors | year | region|
|------------------------

or by NURSE AND SEX
-------------------------
|nurses | year | sex|
|------------------------

Can someone please help me with this sql statements

[Matthew1980]

Hi there JuicyScript,

You might want to post this particular question in the sql forum [webmasterworld.com], lots of specialists in there eager to help!

Cheers,
MRb