Need some database and php help using dreamweaver cs4

[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

[ChemicalBliss]

You want to lookup MySQL Join Tutorials.

 

Basically you use the unique ids of your customers with a field (maybe named customer_id) that would hold the id that item belonged.

Then using a single mysql statement (INNER/OUTER JOIN) you can select both tables where you only get results that: customer_id = ID of customer row.

 

Googling will get you much more detailed examples

 

hope this helps