> Hi. Im using MySQL and as part of my tables I have titles (of stories).
> My question os in regards to outputing those titles. Some of the titles
> begin with words such as 'The', 'A', 'An', etc. Is there a way to order
> these particular titles based on the second word in the title??

Late reply -- I don't check this folder that often.

I had this exact problem.  Don't bother with temp tables, or extra fields,
or anything like that.  You can build it all into your MySQL query.  A
resident MySQL expert gave me this recipe (well, one very similar):

  $query = 'SELECT title_field, some_other_fields
            FROM some_table
            WHERE some_field = 'some_criteria'
            ORDER BY TRIM(leading "An " from
                     TRIM(leading "A " from
                     TRIM(leading "The " from title_field)))

No fuss, no muss.  You don't have to worry about what order they were
inserted in, artificially munging your data, or anything else.


[ joel boonstra | [EMAIL PROTECTED] ]

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to