SOLVED – Alphabetical order on initial load
-
I’ve seen a lot of people here ask how to sort stores by alphabetical order. I also needed to fix this for my site, and finally found out how to do it.
File: sl-xml.php
For my current version this code starts at line 58. Look for my comments to see where the additional code was added.
$num_initial_displayed=(trim($sl_vars[‘num_initial_displayed’])!=””)? $sl_vars[‘num_initial_displayed’] : “25”;
// Select all the rows in the markers table
$query = “SELECT sl_address, sl_address2, sl_store, sl_city, sl_state, sl_zip, sl_latitude, sl_longitude, sl_description, sl_url, sl_hours, sl_phone, sl_fax, sl_email, sl_image, sl_tags”.
” $sl_custom_fields”.
” FROM “.SL_TABLE.
” WHERE sl_store<>” AND sl_longitude<>” AND sl_latitude<>””.
” $sl_param_where_clause”.
/* FIX START */
” ORDER BY sl_store ASC”.
/* FIX END */
” LIMIT $num_initial_displayed”; //die($query);
- The topic ‘SOLVED – Alphabetical order on initial load’ is closed to new replies.
