I have a php/mysql page that people can add articles to and I want the \"admin\" page made so I can move the posts around by order of what I think should have priority or whatever but I am not sure how to do that. I could have an \"orderby\" field but how would I update the records below or above that record so their orderby number changes? Example:
article|orderby
texta|1
textb|2
textc|3
textd|4
If I clicked on the link to move textc up (change orderby number to orderby-1 or 2) how does the textb record know that it should now be orderby+1 or 3? What would happen, is there would be two with the same orderby number which wouldnt get the results I want.