Xtremer360 Posted September 21, 2008 Share Posted September 21, 2008 I have a table of events and each event has its own unique id. I have a second table of matches. What I want to know is how do I link each match in that table to the event id, and also give it a position entry as well. Quote Link to comment https://forums.phpfreaks.com/topic/125138-solved-linking-things-in-muliple-database-tables/ Share on other sites More sharing options...
Adam Posted September 21, 2008 Share Posted September 21, 2008 Could try JOINs.. http://www.google.co.uk/search?hl=en&q=mysql+join Or perhaps this may help.. http://www.astahost.com/info.php/mysql-multiple-tables_t12815.html Adam Quote Link to comment https://forums.phpfreaks.com/topic/125138-solved-linking-things-in-muliple-database-tables/#findComment-646794 Share on other sites More sharing options...
Xtremer360 Posted September 21, 2008 Author Share Posted September 21, 2008 How inside of phpmyadmin do I make a table column field a foreign key instead of a primary key Quote Link to comment https://forums.phpfreaks.com/topic/125138-solved-linking-things-in-muliple-database-tables/#findComment-646801 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.