I havea script I am using on my site that was written in mysql. This is an add on function to my site and needs to be converted to mysqli, and then some changes will be needed to fit my requirements. Most of the code is already written, although I am not 100% sure how much can be used, but it will definitely give a great head start.
1.) Look is similar to attached picture
2.) Get array of player picks from all weeks (part of existing code)
3.) Compare player picks from another table that holds schedule and result (part of existing code)
4.) If team chosen is winner, green cell
5.) If team chosen is loser, red cell
6.) If team chosen part of buy back, orange cell
7.) If game has not started, shows image (question mark like attachment, or lock picture)
8.) Sorted by SCORE column, weeks won
9.) If loss and buy back was used, must allow to keep calculating until next loss
I believe most of the requirements above are included in the script already, but will need some modifications/fixing to give the end result.
Must comply to current CSS bootstrapping
As mentioned, most of this code is in place, just meeds to be converted to mysqli and modified to adjust to my requirements. How it was built already is not the same, but very similarn