Search feature

[martini55]

When a user does a search, only the cities, states and countries of registered users appear. Is there anyone to make them appear in alphabetical order?

[Eric Barnes]

I just made the change for v3.1 but if you have the developer edition you can open the search.php file and after each query add an ORDER BY clause.

For example:

PHP Code:

$sSQL="SELECT DISTINCT `city` FROM ".PREFIX."users WHERE city <>''"; 


To:

PHP Code:

$sSQL="SELECT DISTINCT `city` FROM ".PREFIX."users WHERE city <>'' ORDER BY city ASC";