Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search mysql_query

Status
Not open for further replies.

lineb

Technical User
Feb 24, 2003
1
CA
Hello!
I am using mysql and php.
I want to set up a page on our site so that our customers can find a part no. by making some selections.
One part no. can apply to several configurations and model.

Here's a sample of the table:
Partno Application Configuration Model
123 pressure B1 White
124 vacuum B1 Black
125 pressure C1 White
126 pressure D1 White
123 pressure C1 Black
...

First, the customer selects the configuration, ex: C1, then a query needs to be done on that result to filter for the application, ex: pressure. Then again from that result the model ex: black. The customer is then left with part no. 123.
Is it possible to have this done on one page?
Thanks you,

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top