madhead29 Posted August 22, 2007 Share Posted August 22, 2007 Hi all, what i am trying to do is like this website: chippeduk.com in the search area (bottom right), where the user selects a make (all fields grab from the database), then selects a model, then they select the fine tune, then they click search this will bring up the information about the car they have picked. How would i do this, would i use multiple tables and then link them together via an id? i am new to PHP/MySQL but very willing to learn. Thanks in advance. I have looked around many forums inc the devshed forums but i can't seem to find that i am looking for. How would i setup the database structure for this type of system? using two tables? how would i link them to each other. I am willing to pay someone to help me with this as i need it done ASAP PM me for more info. Regards, CM. Quote Link to comment Share on other sites More sharing options...
jvrothjr Posted August 24, 2007 Share Posted August 24, 2007 make table 1 - ID 2 - Make Model table 1 - Make ID 2 - Model ID 3 - Model Year table 1 - Model ID 2 - Year Use a query of the table to display in the drop down box and as user selects one option display the next box with an if statment and the prior selection with set the display query for the next box and so on using the onchange java trigger to process the action. Dont have a sample code at this time with me but its not that hard Quote Link to comment Share on other sites More sharing options...
MadTechie Posted August 24, 2007 Share Posted August 24, 2007 this might be useful Dynamic DropDown PHP/AJAX Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.