RE: [PHP-DB] Errors getting count(*) result
| From: | Jeroen ten Berge | Date: | Fri, 18 Aug 2000 06:56:19 +0000 |
| Subject: | RE: [PHP-DB] Errors getting count(*) result | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2142@lists.php.net to get a copy of this message | ||
The statement is wrong, use :
"select count(*) as MyCount from amazoncd"
-----Original Message-----
From: Ian Evans [mailto:ianevans@friedspamdigitalhit.com]
Sent: Friday, August 18, 2000 04:18
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Errors getting count(*) result
Richard Allsebrook wrote:
> $cntquery = "SELECT count(*) FROM amazoncd AS MyCount";
Hmm...don't know if that's a MS SQL/ODBC quirk, but when I tried that I
rec'd this message:
Warning: Field MyCount not found
--
Ian Evans
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net