I'm gonna try to explain what i'm after here.
I have lets say 11 rows in a mysql table with ID Name and Counter columns. ID is on auto_increment. Each time I add one row in this table with a php script the row gets for example 118 - Doofus.jpg - 12. By this I mean that every row gets an unique Counter number, but not random, instead they have to be from 1,2,3,4,5,6,7 etc etc. So that the first row always gets 1 and the last row always gets the last number in the order, in this case 12.
When a row in this table is deleted, also via a PHP script, the range of number gets messed up. Maybe I delete a row with the Counter number 5. Now I have a gap. So what I want to do is that everytime I load a page I want these numbers rearranged so that it always is 1,2,3,4,5,6,7 etc etc.
I hope I made myself clear and I hope someone can help me, I've tried loops with mysql Update but to no avail.
Thanks for all your help!