ed89 Posted February 1, 2008 Share Posted February 1, 2008 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 Link to comment https://forums.phpfreaks.com/topic/88865-basic-sql-query/ Share on other sites More sharing options...
pdkv2 Posted February 1, 2008 Share Posted February 1, 2008 use and clause in your query to compare other columns Link to comment https://forums.phpfreaks.com/topic/88865-basic-sql-query/#findComment-455139 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.