[PHP] sorting data from a field

2002-03-26 Thread Chuck Barnett
Hello again :) 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 field if I don't have to. Any help

Re: [PHP] sorting data from a field

2002-03-26 Thread Miguel Cruz
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

RE: [PHP] sorting data from a field

2002-03-26 Thread Darren Gamble
Subject: [PHP] sorting data from a field Hello again :) 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

RE: [PHP] sorting data from a field

2002-03-26 Thread Darren Gamble
) 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. Please consult your particular

Re: [PHP] sorting data from a field

2002-03-26 Thread javier
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.

RE: [PHP] sorting data from a field

2002-03-26 Thread Rick Emery
, February 03, 2002 2:50 PM To: PHP General List Subject: [PHP] sorting data from a field Hello again :) 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