you can extract and sort on the last name:
mysql> select substring(myname,locate(" ",myname)+1) as lname from mytable
order by lname;
this assumes names are stored as "john doe", that is with a space separator
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Sunday
To do that is it necesary to loop the $result variable and assign each
array($name => $value) ?
> Alternately, you can load all of the unsorted results into an associative
> array, and use PHP's native sorting functions (such as ksort() ) to sort the
> results.
>
>
(403) 781-4948
-Original Message-
From: Darren Gamble [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 2:13 PM
To: 'Chuck Barnett'; PHP General List
Subject: RE: [PHP] sorting data from a field
Good day.
You can do this using the "ORDER" clause in SQL. Pleas
Good day.
You can do this using the "ORDER" clause in SQL. Please consult your
particular database's documentation for more information.
Alternately, you can load all of the unsorted results into an associative
array, and use PHP's native sorting functions (such as ksort() ) to sort the
results
On Sun, 3 Feb 2002, Chuck Barnett wrote:
> I have a db field that holds the first and last name of a person. Is
> there a way to sort by the last name in that field?
>
> The whole reason for this is to populate a select box sorted by last name.
>
> I don't want to go back and create a separate
5 matches
Mail list logo
