Support Forums

Old 05-01-2006, 07:22 AM   #1
Member
 
Join Date: Apr 2006
Posts: 80
Rep Power: 13
martini55 is on a distinguished road
Default Search feature

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?
martini55 is offline  
Old 05-01-2006, 01:28 PM   #2
68 Classifieds Staff
 
 
Join Date: Mar 2006
Location: Belmont, NC
Posts: 4,436
Rep Power: 101
Eric Barnes is a jewel in the rough
Default

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"
__________________
Eric Barnes
68 Classifieds Developer
Please do not send me a private message asking for support. Instead use these open forums or our ticket system.

Customer Area | Issue Tracker | Documentation | 68C Mods | Submit a Ticket | Twitter
Eric Barnes is offline  
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
city drop down won't search NetGirl v3.1 Questions & Support 7 12-11-2006 12:15 AM
Search in Navigation bar marketingsolutions v3.1 Questions & Support 0 11-02-2006 01:10 PM
Aligning the "zip code," etc. search fields spaceboy v3.1 Modules & Modifications 5 09-09-2006 03:27 PM
Drop Down Search Issue CB v3.1 Questions & Support 2 06-23-2006 01:04 AM
Advanced Search Template sporthorsebreeder HTML, CSS, and Design Help 6 04-05-2006 05:25 PM


All times are GMT -4. The time now is 02:30 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0