try this
here is a simple php page with the code i mentioned.
using the rowcount of the table in a separate recordset and setting the modulus variable to this value means that the page should work whatever the number of rows in the table.
give it a try
(you will need to edit the connnection name etc)
** after submitting this attachment, I think that floor() is a better function than round, as it will always round down, so any part weeks are ignored.
using floor as the argument, change the where clause on line 44 to
WHERE topTenListID = (mod(floor(datediff(curdate(), '2010-01-01')/7),%s)+1) LIMIT 1
**
