Searching in different table with multiple values

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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.

Re: Searching in different table with multiple values

RAJ wrote:
Quoted text here. Click to load it

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.

Site Timeline