Hi guys,
Right ok lets see if i can get this out my head.
DB setup
mID = autoincrement ID
mName= string info
mImg = string info
mOrder = number
Right ok so lets say i have 10 records
so mOrder would be 1-10 for each record.
Right so some time down the line i might want to change the mOrder for record 8 to 1. So record 1 would need to have the mOrder updated to 2 and so on for each other record
How do i do this?
Thanks for any help suggestions