Re-ordering result (rank)

[eluser]ELRafael[/eluser]
[quote author="elitemedia" date="1190855880"]ELRafael you didn't understood the point. I will try to explain more:

It's not according to the user choice, it is for a backend, letting the admin decide in wich order will appear results for the users, so the order of each results have to be recorded in the DB permanently. For that I created a DB column "rank" and while displaying view to user simply ORDER BY rank

My problem isn't in the public site where users view results but it is on how to handle this for the admin pannel, for exemple with arrows up and down while clicking this move results up or down and then how to do it with PHP[/quote]

oooooooops 8-/

ok, you need something like this:

- There's a list of products, with these 3 options to rank: Name, Price, Size
- Another list of person, with Name, City and Age
- The price must appears first than size and name.

But you can't use javascript, right?

I don't see much difficult... Put on the arrows (up and down) a href to php that re-orders (update the field rank in your db).

If is not this your doubt, i give up :zip: