Alot tougher than I thought it would be.

Dolemite50

Hi,

I have a site that allows people to upload songs and they appear as a list on their personal page. I currently have the paths stored in mysql and they are being sorted by date like this:

SELECT * from mp3s where userid='$userid' ORDER BY songDate DESC

I have had many requests from members who want the option to sort them manually. I am thinking that I can add a column to the mp3s table called order_option and set it to one if a member decides to manually sort. That way it will sort by date if (order_option != 1).

I am thinking I add one more column called order_number that I can use for assigning the order integer from sorting. So if I echo the songs with an incrementing $i and two up and down arrow images, it would look something like this:

First Song's Title MoveUp MoveDown
Second Song's Title MoveUp MoveDown
Third Song's Title MoveUp MoveDown

Heres about where I'm stuck. I am thinking that in order for this to work I will have to refresh the page and run a mysql query every time that an arrow is clicked. Is that a big problem or is there a better method that I could use for this?

Thanks for any help.

rehfeld

unless you want to use javascript, yes you will need to refresh the page.

heres a nice js solution though
http://www.kryogenix.org/code/browser/sorttable/

Dolemite50

Hi,

Thanks for the link. That wasn't quite what I was looking for. That would allow you to sort by any column but I need to be able to have the users define the order.

This seemed like it would be so easy but its turning out to be extremely hard. has anybody found a PHP tutorial for this?

Thanks

rehfeld

oh ok, sorry i guess i replied before i finished reading your entire post. i know what you mean now.

i did it once but dont have the code anymore to show you. the way i did it was pretty ugly though, but it did work.

if you just want moveup movedown buttons/links, it shouldnt be too hard though. when i did it, i didnt use up/down links, i had a small text field next to each element and they could manually type the order in. it was difficult because i had to deal w/ moving a few at a time, and deal w/ them trying to put 2 elements in position 3 for example

i would think though, if you just move 1 at a time, you could just assign an id, which corresponds to the array key.

then if ?cmd=up&id=4

you would swap the positions of elements 3 and 4, then reindex the array.

does that make sense?