The issue here is that you aren't getting an index of "Company" from that query. It is probably stored under the index of "UCASE(Company)". Try:
$Query = "SELECT UCASE(Company) as ucCompany, Icons, ID,..."; Then the ucCompany field will contain your capitalized company data. Jon -----Original Message----- From: Niklas Lampén [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 2: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]