Is my script valid?
$result = mysql_query("SELECT * FROM users WHERE position_applied LIKE '%$search%' AND status LIKE '%$status%' AND years_exp == 1");
What do you mean by valid? There may be a syntax error in your SQL statement (years_exp == 1 should probably be years_exp = 1), but your PHP code is syntactically correct.
Thanks laserlight. I was doubted by that specifically, the years_exp == 1, since you corrected it, then it must be years_exp =1. Is that the conditional syntax for (is equal to) in a query?
Both comparison and assignment, depending on context.
Consider Assignment, followed by comparison
UPDATE tbl SET field = 1 WHERE field = 2
