Order By

[arsenalfan14]

If you go to this page, you can click on any of the headers in the table, 'Apps', 'Stats', 'Goals', etc and it takes a person to a page sorted by that.

I'm just curious as how that can be done, so on my page I can do

page.php?team_id=1 ORDERED BY goals

Cheers

[drawmack]

Take a look at the URL when you click on a field. It passes a parameter called Order with the value of the field you clicked on.

This is pretty easy to set up. Have you script check this parameter. If it exists and is valid then order your query by that field otherwise give it a default field to order by.

[arsenalfan14]

Can you help me? I can't figure it out.