I am trying to get my list of customers to sort alphabetically, ignoring whether the name strats with an uppercase or lowercase letter. Currently the sort order lists all names A-Z followed by all names a-z. I just want all names Aa-Zz, ignoring case.
I can see in admin/model/sale/customer.php the following code (line 251):
Code: Select all
if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
$sql .= " ORDER BY " . $data['sort'];
} else {
$sql .= " ORDER BY name";
}
Obviously I don't know much PHP! Any help appreciated.
TIA