By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Searching in different table with multiple values

P: n/a
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.

Dec 18 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
js*******@attglobal.net
==================

Dec 18 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.