I have a table of images which contains 3500 records.
The site is already live.
Now, in the frontend i want to change the display order of images.
Right now it displays in the order it is inserted.
I wrote code so that the ids can be swapped from backend but even then it won't help.
Its now not possible for me to change queries in frontend in each and every location to write " order by id"
Is there any other way out ??
Right now when i say :
SELECT id, imageh, imagew, filename FROM picture WHERE pictures_siteid =212 LIMIT 13