aaricwon Posted February 19, 2008 Share Posted February 19, 2008 I want to make a database of martial artists (brazilian jiu jitsu) where you can search by name and pull up that persons stats (wins/losses/draws) and a list of each time they have competed/who they fought. The person they fought will be a link and when you click on that, it will be THAT persons stats etc. Here are a couple sites that have it. This 1st one has exactly what I want. How do they get all of their info? http://www.combatrec.com/search.php Link to comment https://forums.phpfreaks.com/topic/91954-how-do-you-make-a-db-like-this/ Share on other sites More sharing options...
aaricwon Posted February 19, 2008 Author Share Posted February 19, 2008 I am amazed with all of the information these guys have too! Anyone? Link to comment https://forums.phpfreaks.com/topic/91954-how-do-you-make-a-db-like-this/#findComment-470932 Share on other sites More sharing options...
Barand Posted February 19, 2008 Share Posted February 19, 2008 One basic design might be [pre] fighter match venue ======== =========== ========== ID ----+ ID +-- ID firstname | match_date | venue_name lastname | venueID ----+ city +-- fighter_A state +-- fighter_B winner (A or B) duration result [/pre] Link to comment https://forums.phpfreaks.com/topic/91954-how-do-you-make-a-db-like-this/#findComment-470958 Share on other sites More sharing options...
aaricwon Posted February 19, 2008 Author Share Posted February 19, 2008 LOL you have already gone over my head. I am new to this and looking to learn how to create this. One basic design might be [pre] fighter match venue ======== =========== ========== ID ----+ ID +-- ID firstname | match_date | venue_name lastname | venueID ----+ city +-- fighter_A state +-- fighter_B winner (A or B) duration result [/pre] Link to comment https://forums.phpfreaks.com/topic/91954-how-do-you-make-a-db-like-this/#findComment-470962 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.