Database Forum
Web Database Register Members List Calendar FAQ

 
Go Back   Database Forum > PHPMagic Discussions > Customization
User Name
Password

Reply
 
Thread Tools Search this Thread Display Modes
Default Auto select
03-18-2012, 04:28 PM #1  

alexmark
Junior Member

 
Status: Offline
Posts: 2
Join Date: Mar 2012

Hi everyone I am new to PHP Magic and am trying to find a solution to a problem when setting up the data base.

What I want to do is creat a data base that would allow the selection of a Make of a car from a drop down menu. Then you would select the Model of the car.

What I have so far is the Make set up with a list value set up for Make.

How do I set up the tables etc for the Models? So when some one selects a Make the Model selection would give Models just for that Make.

Do I have to creat a table for each Make and each model?

Help I am lost.
Reply With Quote

Default
03-18-2012, 04:42 PM #2  

Sandman
Moderator

 
Status: Offline
Posts: 98
Join Date: Mar 2005

Maybe this post will help.
Reply With Quote

Default Yes I can connect them together for out put
03-18-2012, 04:52 PM #3  

alexmark
Junior Member

 
Status: Offline
Posts: 2
Join Date: Mar 2012

No I am looking more for teh information on how I create the db. ie do I make a seperate table for each Make and each Model or can I just place them in one tale.

Table 1 would be Make (this produces a drop down list.)

Table 2 would be model (again by drop down)

Or do I

Table 1 Make
field 1 Jag
field 2 Ford
field 3 Saab

Tabel 2 Model
field 1 Jag with list
field 2 ford with list
field 3 Saab with list

Basicaly I need to know how to set up the db to start with.
Reply With Quote

Default
03-19-2012, 05:36 AM #4  

Lana
Senior Member

 
Status: Offline
Posts: 110
Join Date: Oct 2007

Yes - you will need a table for make and a table for model. There would be a foreign key relationship between them.
Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 09:04 PM.

Powered by: vBulletin Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Database Forums

Help support our forum assistants and product development ->

go to top go to top