cnl83 Posted February 9, 2011 Share Posted February 9, 2011 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 Quote Link to comment Share on other sites More sharing options...
ChemicalBliss Posted February 9, 2011 Share Posted February 9, 2011 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 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.