[PHP] Re: PHP array or SQL problem

"Dean Householder" <[EMAIL PROTECTED]> wrote in message 007301c19d97$21968660$d5246541@daylightcreations">news:007301c19d97$21968660$d5246541@daylightcreations...> >I've got a database with lname (lastname), fname (firstname), and nickname. > >What I want to do is search by either first name or

[PHP] RE: PHP array or SQL problem

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 www.chessish.com