Searching in different table with multiple values

[RAJ]

I have one php form where i will have around 5 text box, 2 dropdown
and two select box.
now i will post the values from this form may be all values or may be
some of these values.
i need to search and retrieve from different tables from same database
with all these possible combination.

this is actually a employee detail project where i need to search for
employee whose details match with this combination of data.

[Jerry Stuckle]

Re: Searching in different table with multiple values

RAJ wrote:

I have one php form where i will have around 5 text box, 2 dropdown
and two select box.
now i will post the values from this form may be all values or may be
some of these values.
i need to search and retrieve from different tables from same database
with all these possible combination.
>
this is actually a employee detail project where i need to search for
employee whose details match with this combination of data.
>
>

Not a problem. Just check each field and, if it's not empty, add it to
the WHERE clause in your SQL statement. Just standard string manipulation.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===