Code: Select all
andPlease help:
How can i pass the parameter below to an sql query?
Code: Select all
$searchItem = $_REQUEST['searchItem'];
$sql = "SELECT committee_name, decision.decision_id, decision_date,
indicator_name, indicator_status, indicator_remark
FROM committee, decision, indicator
WHERE decision.committee_id = committee.committee_id
AND decision.decision_id = indicator.decision_id
AND decision.committee_id = indicator.committee_id
AND decision_name LIKE '%$searchItem%'
ORDER BY decision.committee_id ";