RE: [PHP] mySQL problem
| From: | Jon Snell | Date: | Fri, 02 Nov 2001 15:31:59 +0000 |
| Subject: | RE: [PHP] mySQL problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73271@lists.php.net to get a copy of this message | ||
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:niklas.lampen@publico.fi]
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