Re: [PHP-DB] php-mysql-and the elusive eval statement....

2001-11-01 Thread Petr Tuma
f a beer. > Yea, Ah woke up this mornin' an' I had myself a beer. > The futures' uncertain and the end is always near. > -Jim Morrison, "Roadhouse Blues" > > Fill with mingled cream and amber, > I will drain that glass again. > Such hil

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

2001-11-01 Thread Petr Tuma
in case it will not work find out in the 'list of changes' (for version 3.23) if this feature is not new. In such case tell whoever to upgrade. :( I can't find any error in your query (and at least at 3.23 it's working!) Regards On Thursday 01 November 2001 10:19, you wrote:

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

2001-10-31 Thread Petr Tuma
Hi, there was an typing error 'from Title' should be 'from Titles'. Anyway it's working for me. What error message it produce? On Thursday 01 November 2001 05:09, you wrote: > Petr Tuma wrote: > > select *,(case when Title like 'The %' then subs

Re: [PHP-DB] MySQL: Alphabetizing title results in library format

2001-10-31 Thread Petr Tuma
n Title like 'An %' then substring (Title, 4, 255) > else Title > end > > That worked like a charm, yet MySQL doesn't seem to accept that. Any > solutions or advice? -- Petr Tuma IT Manager, M.Ward Manufacturing -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]