PHP archiving script

[leeandrew]

I need a script that runs once per week.

At the specified time the script collects certain cell data from MySQL DB in a certain table and deletes it.

Before it deletes it it sets a value accordingly in another cell as per what the data shows in the cells its about to delete..

 

e.g.

liverpool = 91 points

man utd = 85 points

arsenal = 78 points

chelsea = 76 points

 

the script reads that liverpool have the highest amount of points so places a "1" in the new cell. man utd have the second highest amount so places "2" in the new cell etc... basically it saves the positions each team has each week based on how many points they have gained throughout the week.

 

After the positions have been saved, the cells are emptied. So that each team can start fresh for the next week. Then the week after the script does the same and so on.

 

Is this possible to do in php/mysql? If not can you suggest a way i can do it? I already have the position vs points worked out. So essentially it would only need to collect the position and empty the points cell.