Query question

[genista]

Hi all,

Hopefully something very simple, have tried numerous rewritings of this but it still does not work....

$query = "select county
     , area_covered1
     , area_covered2
     , area_covered3
     , supplierid
     , username
	 , hairdresser 
  from suppliers 
 where '$county' in
       ( county         

       , area_covered1 
       , area_covered2 
       , area_covered3 )
       AND where hairdresser='true'
order 
    by username";

The part that isnt working is the "AND where hairdresser='true'", any ideas what this should be?

Thanks,

G

[johanafm]

you only ever use one WHERE.

WHERE '$county' in
       ( county         

       , area_covered1
       , area_covered2
       , area_covered3 )
       AND hairdresser='true'