ordering the rows manually (Script needed)

[computerages]

hey eveyone!

I am looking for a php script which would let me order the rows manually instead of table's id, or something like it...

If you still don't understand what I am looking for:

http://img149.exs.cx/img149/5218/untitled7fk.png

waiting for your reply...thanks!

[nemonoman]

Lets assume you already have 2 tables:

menu

id
menutext

and

user

userid
username

You'd then create a THIRD table

usermenuorder

userid
menuid
order

If you had 3 menu records

id 1 --- First Menu
id 2 --- Second Menu
id 3 -- Third menu

user 1 could create 3 records
userid 1
menuid 1
order 3

userid 1
menuid 2
order 1

userid 1
menuid 2
order 2

Use a sql query like this to return menus in user 1's desired order:

SELECT menutext
FROM menu
INNER JOIN usermenuorder
ON menuid=menu.id
WHERE userid=1
ORDER BY usermenuorder.order

[computerages]

Originally posted by nemonoman

Thanks for the help, it is greatly appreciated! Could you please also tell me that how would that script look like, which will update the order?

Thanks!