Sorry, I mixed 'company' with 'country' in the example query, it should have been...
Code: Select all
$query = @mysql_query("SELECT `cid`, `company`, `name`, `town` FROM `clients` ORDER BY `company`, `name`");
Basically I want to return 'by alphabetal order' the text values from two columns within in the same table, so the results would read:
Entries starting with A from both company and name columns
Entries starting with B from both company and name columns
Entries starting with C from both company and name columns
Entries starting with D from both company and name columns
Entries starting with E from both company and name columns
Entries starting with F from both company and name columns
etc.
and not:
Entries starting with A from company column
Entries starting with B from company column
Entries starting with C from company column
etc.
Entries starting with A from name column
Entries starting with B from name column
Entries starting with C from name column
Entries starting with D from name column
etc.
Thanks