problem with SQL statement

amarafzal

Can you help me?

ive got a problem with this sql statement:
$query = "SELECT * FROM $table_name WHERE (job_summary OR job_title LIKE '%$keyword%')";

it works fine in that it pulls out the results i want it to but the problem is it pulls out one result which does not match the keyword, it pulls the extra result what ever the keyword is.

does anyone know why? and how i can fix this?

matto

there's an incomplete condition, correct:

$query = "SELECT * FROM $table_name WHERE (job_summary LIKE '%$keyword%' OR job_title LIKE '%$keyword%')";

amarafzal

thats wicked, THANKS SO MUCH

amarafzal

One thing though i want to add 2 more drop down fields to narrow there search ALONG with the keyword, the below works. But i also want to give them the option of choosing a keyword and region or region and job_sector or just by job sector etc. What do i need to do that with the statement below?

$query = "SELECT * FROM $table_name WHERE (job_summary LIKE '%$keyword%' OR job_title LIKE '%$keyword%') AND job_sector = '$POST[job_sector]' AND region = '$POST[region]';";

Is it possible to use AND OR operators togather? that will solve this problem?