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? Link to comment https://forums.phpfreaks.com/topic/38673-new-table/ 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? Link to comment https://forums.phpfreaks.com/topic/38673-new-table/#findComment-185815 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 ? Link to comment https://forums.phpfreaks.com/topic/38673-new-table/#findComment-185828 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. Link to comment https://forums.phpfreaks.com/topic/38673-new-table/#findComment-186209 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.