PHP REORDER DATABASE ITEMS

Basically I want to make some minor tweaks to the backend design and add the drag and drop functionality of [login to view URL] to reorder my listings. Here are some tutorial links that explain how to do this: [login to view URL] [login to view URL] Existing System Screen Shots: [login to view URL] Category Editor [login to view URL] Current Listing Editor View Please see attached image: [login to view URL] I want to add the ability to reorder listing items within a category via drag and drop using the [login to view URL] drag and drop reordering script. I also want you to be able to reorder by clicking on up and down arrows, as shown in the image. To see this in action go to: [login to view URL] even better if you could have it work like this: [login to view URL] So when you hover over any non-link on this section it will show the move cursor (with the 4 arrow heads), if you hover over the move up/down link or edit listing link it will show the regular and with pointer finger cursor. Look at the image I created - it has a border around the section being moved - I would like the border to be coded on there as well. The relavent code for this section is in the file ../include/[login to view URL] starting at line #1139. Possible logic: Add a field to the database to specify listing order, probably on the table default_classlistingsdb call it something like "listingorder" Since each item is assigned to a category there are a couple options for the listingorder sorting. The first is you can have repeated values per category so within each category you can have a listingorder value of 1 - X. Or you could have the listingorder actually be unique regardless of category, in this case when you're making the process to change the order you'll have to actually give the original listing the "listingorder" value of the listing you are moving. This can get to be a somewhat tricky sql operation when you are using the drag and drop ordering system and have to update all of the other listings' "listingorder" value at the same time. Also please notice the few visual changes I made on this and make these as well. Category Editor Changes: See [login to view URL] Pretty much the same changes as above in terms of drag and drop functioning. I also want this to be adjusted to match the way the listing editor looks - as shown in the jpeg. Where the category title is actually a hyperlink to modify it, and the rows are shaded differently. Edit Images Changes: Please see [login to view URL] The only difference here is the portion with the thumbnails at the top. This should be the easiest to do as it's not dealing with multiple categories and such. This also already has an image order function built in. I basically want the drag and drop ordering to integrate with the existing image ordering method, as pictured. One Portion which I didn't put into the jpeg that I would like is a "featured photo" function that allows you to select one image to show up as the first large image on the front end. I'm picturing something like a "Feature this Photo" link right above the link to delete the image - by default the first photo in any listing will be the featured photo. You can only have one featured photo, and if a photo is featured it will say "Featured Photo" in place of the "Feature this Photo" link.