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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/88865-basic-sql-query/#findComment-455139 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.