Steph,
> 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.
HTH!
--
[ joel boonstra | [EMAIL PROTECTED] ]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
