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&igr;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]