Sort Members By State

[ranger2kxlt]

I think this would be a great hack and definately useful for boards with chapters and stuff where people get together on a regular basis.

Anyways heres what i need. I will be changing the location field on the profile into a text box and a drop down box. The drop down box will contain the states and canadian provinces... whatever... and the text box will be for the city.

It will still display the same way as it always has and everything, just i was wanting to be able to sort members by state and i think this is the only way i can get it done. Anyways... after this i am lost on what to do to get it to sort this way. I know how to do the query to make it sort, but i cant make it support more than one page?? How can i do that?

PHP Code:

$DB_site->query("SELECT blah, blah, blah, state, blah FROM user ORDER BY state ASC"); 


Can someone write a hack to have this done?