A Tiny bit of MySQL Help.

[Waffle]

$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

– Sectors
– Title
– Location

[bi5on]

$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.

[Waffle]

This code has made an error on a line lower down.

$count = mysql_num_rows ( $query ) ;

[bi5on]

Can you share your code including my query above.

[TT_Mark]

I recommend not selecting ‘*’ either as it is bad practice. Select the columns you need by name

[Author]

Posts