Jump to content


Photo

move up/move down


  • Please log in to reply
No replies to this topic

#1 dreed75

dreed75
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 13 August 2003 - 12:49 AM

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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users