dynamic21 Posted January 4, 2008 Share Posted January 4, 2008 Hi guys, I'm using MySQL 5, and I just needed an idea of how to structure my database. I'm quite a noob to this, however I do know some basics. I need to keep track of users and their previous achievements. So, lets say, I have a table of users who run track. In this table contains their names, addresses, and 40-yard dash times. Now, I'm stuck on the idea of keeping track of a list of each individual's previous accomplishments. For example, I'd like to keep in the database that User-1 has won tournaments in City1, City2, and City3, while User-2 has won tournaments in only City3 and City4. How do I go about storing this "list" for each user? I'm sorry if my question has been answered before, I've been searching the internet for the past two hours and I just don't think I'm wording my question correctly in google or something. Am I making this much more complicated than it should be? Link to comment https://forums.phpfreaks.com/topic/84554-solved-data-structure/ Share on other sites More sharing options...
revraz Posted January 4, 2008 Share Posted January 4, 2008 Maybe have a table called tournaments id | location | userwon Where id is tournament id, location is the city name, userwon is the id who won it. Link to comment https://forums.phpfreaks.com/topic/84554-solved-data-structure/#findComment-430814 Share on other sites More sharing options...
dynamic21 Posted January 5, 2008 Author Share Posted January 5, 2008 Ah yes, thank you! I thought of that solution as well, but I was concerned there might be a more efficient way of solving the problem. Thanks again, very much appreciated. Link to comment https://forums.phpfreaks.com/topic/84554-solved-data-structure/#findComment-431305 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.