"SELECT UCASE(Company) AS Company...." works great, thanks!
Niklas -----Original Message----- From: Dimitris Kossikidis [mailto:[EMAIL PROTECTED]] Sent: 2. marraskuuta 2001 11:11 To: 'Niklas Lamp¨¦n' Cc: PHP General Subject: RE: [PHP] mySQL problem Try this $Query = "SELECT UCASE(Company) as company, Icons, ID, LogoD FROM feComps...."; List ( $company, $icons, etc ) = mysql_fetch_row( ); > -----Original Message----- > From: Niklas Lamp¦Én [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 02, 2001 10:22 AM > To: Php-General > Subject: [PHP] mySQL problem > > > I'm having a wierd problem with mySQL query. > > $Query = "SELECT UCASE(Company), Icons, ID, LogoD FROM feComps...."; > > returns right amount of rows, but field Company is empty. > > $Query = "SELECT Company, Icons, ID, LogoD FROM feComps....."; > > works fine. > > > First query works great when I run it in shell. What could cause this? > > > Niklas > -- PHP General 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]