Basic SQL query

[ed89]

Hi,

 

Apologies for the newbie question, I'm quite new to php/mySql.

 

In my app which is used to search a db of job postings I have;

 

$sql = "select * from jobs_listing where location = " . "'" . $vals['location'] . "'";

 

I also have fields that are named; sector, salary, type. I want these to be included in the select, but how do I do it?

 

i.e; Display if the user searches to display jobs only which are based in England, are in the Voluntary sector, is paid £xx and is a permanent role.

 

thanks in advance

 

Ewan

 

[pdkv2]

use and clause in your query to compare other columns