Need to link two tables using dreamweaver cs4

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
cnl83
Forum Commoner
Posts: 44
Joined: Mon Sep 26, 2005 10:34 am

Need to link two tables using dreamweaver cs4

Post by cnl83 »

I created a tabase with two tables.

1) Customers
2) Software

My customers form adds data to the customers table, but on my form I want to assign one or more pieces of software to that particular customer. How do I link up the tables to work that way? My customers table has a unique id.

Im using dreamweaver and php my admin

Thanks in advance
User avatar
MindOverBody
Forum Commoner
Posts: 96
Joined: Fri Aug 06, 2010 9:01 pm
Location: Osijek, Croatia

Re: Need to link two tables using dreamweaver cs4

Post by MindOverBody »

Every software should have it's own unique ID. When costumer picks software in form, software's ID should be stored in customers table in specific column.
cnl83
Forum Commoner
Posts: 44
Joined: Mon Sep 26, 2005 10:34 am

Re: Need to link two tables using dreamweaver cs4

Post by cnl83 »

Keep in mind that I will be adding software products regularly. I'll add the software types and brands before attaching a record to the customer profile.

I have attached an image to show what I have in mind. How would I go about achieving this?

What about using internal relations in phpmyadmin.
Attachments
form.gif
form.gif (12.44 KiB) Viewed 185 times
Post Reply