The forums ran from 2008-2020 and are now closed and viewable here as an archive.
$sql = "SELECT * FROM `jobs` WHERE `sector` = '" . $sector . "' AND `title` LIKE '%" . $title . "%'";
Just a quick question, How do I extend this? … Add more options.. coz ive tried loads of things but I cant make it work. Can you help me extend it.. I want to have
$sql = "SELECT * FROM `jobs`
WHERE `sector` = '" . $sector . "'
AND `title` LIKE '%" . $title . "%'
AND `Sectors` LIKE '%" . $sectors. "%'
AND `Location` LIKE '%" . $location. "%'";
you might want to check the case of your `fields` and of your variables $Location $location etc.
This code has made an error on a line lower down.
$count = mysql_num_rows ( $query ) ;
Can you share your code including my query above.
I recommend not selecting ‘*’ either as it is bad practice. Select the columns you need by name