Greaser9780 Posted February 15, 2007 Share Posted February 15, 2007 I want to create a summary table where I can store info to later be displayed. 1)I eventually want to display each clans win or loss streak. Can someone help me on how to configure the table to do this. I already have a table for each game that keeps stats on how many wins or losses each clan has, but I have no idea how to calculate or store a "streak". 2)I also want to have a section of the table that will show the rank of each team which is by most wins in order of descending.Could I use a mysql query to select the data from that table in that order and re-enter it in the new table? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 15, 2007 Share Posted February 15, 2007 Why create a summary table -- why not pull real-time data? Quote Link to comment Share on other sites More sharing options...
Greaser9780 Posted February 15, 2007 Author Share Posted February 15, 2007 I decided to put rank in my game table.For the life of me I cannot figure out how to update and set the rank. I have the table already set up to display the clan name ordered by wins descending. Then everytime a gamer reports the loss I can automatically run the update after the losses and wins are set. UPDATE `game` SET `rank`='?' ORDER BY ASC Can't fill in that ? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 16, 2007 Share Posted February 16, 2007 Well, you'll have to update each of the records in the game table, so you'll need a lot of UPDATE statements... which is why there's no point. 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.