I am wanting to use this technique on my website to determine the game of the week, I am wanting to tick a checkbox on a certain game and it finds the highest value under 'gotw' and adds 1.
I can then list all previous games of the week. All games that have never been a game of the week will just have a default value of 0.
I have the database setup with 2 games of the week already, so I have loads of games with the value '0' under 'gotw' and 2 games with the values '1' and '2' so I would like to detect the highest value '2' and + 1 so it will update the row under 'gotw' with the value '3'
Any help will be much apprechiated, or just a general point in the right direction.
Thanks.