Hi,
I'm having a problem incrementing a value and putting it into an Update statement, my code is as follows:
What I want it to do is place the incremented number by $CurrentRank++; into Rank_Today, but it doesn't work and instead it counts every row in the table and puts that number in every Rank_Today column. Anybody have any idea why I'm experiencing what I am? I've tried putting echo $CurrentRank; and it outputs the correct number to the page itself, but it doesn't send the right value to the database (as I said it sends the total counted number to the database, so if there are 30 rows it would place the number 30 in every Rank_Today column instead of going 1-30).
Any help would be greatly appreciated.
Thanks!