An option is to create a sortfield in your query, something like "SELECT *,
CONCAT(nickname, fname) AS sortfield FROM ORDER BY sortfield". I'm assuming
MySQL and haven't actually tested this. You may need to check the sql
documentation for some of the details.

Tim <> 

        From:  Dean Householder [SMTP:[EMAIL PROTECTED]]
        Sent:  15 January 2002 07:35
        To:  [EMAIL PROTECTED]
        Subject:  PHP array or SQL problem

        I've got a database with lname (lastname), fname (firstname), and

        What I want to do is search by either first name or last name.
Either way, I display the nickname instead of the firstname if it exists.  I
have no problems on the last name, but when I sort by firstname, the people
with nicknames that are very different come up at the place where their
first name (not the displayed name) is.

        For example:

        Adam Smith
        Joe Schmoe
        Bill Somebody

        When Bill Somebody is really William Somebody in the database, his
nickname is bill and that's what's displayed but he 'bill' shows up in
'williams' spot.  Here is my SQL query:

        select * from employees order by fname;

        Should I create an array and sort it there or can I somehow query
MySQL to sort by nickname only if it exists and then by fname?


PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to