multiple where condition

[missLala]

hi...
i want to ask about how to generate a code which can solve the problem that i had to face now...

i need to make a search form... with 3 condition...
user have to enter name, client's department, start date and end date before it can search the result they wanted to have... user can choose to enter all the condition or simply choose none for the condition in case user forgot the specific data to be enter in the form

start date and end date is about a range of date that teh user want to choose..
now my where clause only select the name, and it didnt work on the second and third condition.

so anyone can help me?
do i have to enter a different select and where for each condition(name,client department, start date and end date..)

please i need a solution now

[djjjozsi]

add a condition to your query if that condition is exists only.

<?php
function mres($value)
{
    return mysql_real_escape_string($value);
}

if (!empty($_POST["department"])) {
    $safe_department = mres($_POST["department"]);
    $cond[] = "department like '%$safe_department%' ";
}

if (!empty($_POST["name"])) {
    $safe_name = mres($_POST["name"]);
    $cond[] = "name like '%$safe_name%' ";
}

 if (!empty($_POST["date_from"])) {
    $safe_date_from = mres($_POST["date_from"]);
    $cond[] = "date_field > '$safe_date_from' ";
}

 if (!empty($_POST["date_stop"])) {
    $safe_date_stop = mres($_POST["date_stop"]);
    $cond[] = "date_field < '$safe_date_stop' ";
}

$sql = 'select * from Mytable'; // basic query

if (isset($cond)) // add these conditions together
    $sql .= " WHERE " . implode(" OR " , $cond); 

echo $sql."<br />"; // test in PHPmyadmin

?>