custom ORDER BY
Posted: Fri Jan 30, 2004 7:12 am
I want to ORDER BY a field named TYPE in this order: helm, amulet, shield, weapon, bodyarmour, boots.
Any idea how I would go about this?
Any idea how I would go about this?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
ORDER by type='helm' DESC, type='amulet' DESC, type='cape' DESC, type='shield' DESC, type='weapon' DESC, type='bodyarmour' DESC