[RESOLVED] checking if 2 table fields are not empty

[rooky]

Hi there

I have a form with a drop down list of value set to--all
in which I am trying to select all from a mysql table where 2 table columns are not empty to display results.

eg
$sqlquery ="SELECT * FROM recruitment WHERE jobtitle AND location IS NOT NULL";

this brings up nothing jobtitle and location are form( post) values .Both table fields are set to not null in table so it should display everything in these two columns I assume. but does not work.

thanks rooky

[tomhath]

$sqlquery ="SELECT * FROM recruitment WHERE jobtitle IS NOT NULL AND location IS NOT NULL";

[rooky]

thakyou!!