dreed75

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.