21-02-2006, 02:19 PM
Quote:IBE247 wrote:
So I thought it would be possible to use first a command to transform all in lower case and then format with capitalize
Yes, you could do it there in PHP but it's even better to do this directly in the sql query
example: select a,b,c from flights where UPPER(companyname)='IBERIA'
I don't have the script here, so don't know the original sql query and the exact field name for the company field, but maybe you'll find out yourself.
If not, I'll check later.