Convert bracketed tournament data into mysql tables

Hello, This is a trivial task, SQL allows you to store recursive data into plain table. For example in the most simple variant you may have 3 tables: Tournament (tournament data and other stuff) Player (player data) Match [ - id - tournament_id, - player1_id, - player2_id, - outcome (0,1,2 or any other possible outcome that the reglament permits) - level (starting from 0, it increases each round) - ... additional data ] For the given example Match table will look like (id and tournament ids are skipped): [A,B,1,0] A wins [C,D,0,0] no winner [E,F,2,0] F wins Now if A plays against F and wins we will have [A,F,1,1] - now the level is 1. This will allow easy tracking of the results and displaying stats. Of course the final desing will depend on any additional reqirements you have in order to make it useful. For example if the bracket is seeded (like in Tennis) and what questions do you need the database to answer. Looking forward to working with you! Best regards, Atanas

Hi sir, My name is Leonardo Medina, and I´m from Brazil. I will create a table with teams, and another with matches. I have lots of experience in PHP and Web design. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web Developer / Software Developer working since 1996 in this field, with 5+ years experience in PHP, ASP, HTML, CSS and Javascript (JQuery & Ajax), 8 years in Delphi and 1 year in Java, 2 years of experience in programming stored procedures, triggers, creating tables and relationships for SQL Server, and 10 years in mySQL; 2 year in Solr/Lucene (for full-text searches), Redis and CouchDB. Looking forward to hear back from you. Best Regards

Hi, it's sound the simple project but would you like tell me the detail of you want to save the data into database? I will make a database that has some table but it depends of your detail too. I'll input your data into the database and I'll try to filter as you want. Let me know if you need me to done your project. Thank you, Suwandy

Hi, I need to know your input data, then maybe we could use regular expression or something else to fix your problem. Please contact me. Sincerely, Jason

hi , I wud deliver this in one day. I wud create two table table in mysql databse. table 1; teams columns ={id, name, owner, captain, creation time, update time.} table2 :Matches columns= { id, winning team, defeated team, starttime, endtime, isTied, winningteam points, losertean points} i wud save this imformation in table. For seeing the reports let say, Points table -- I wud create a view where u cud see the detailed points table. One more function/view to have detailed report for each team. I wud discuss more details once assigned . thanks& regards, Bhoopendra

A proposal has not yet been provided

hi. pls contact me.