Re: Count(*)
| From: | Barry Rumsey | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: Count(*) | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16156@lists.php.net to get a copy of this message | ||
Thank you everyone. The "COUNT(*) AS c" worked great.
-------Original Message-------
From: Kai Voigt
Date: Friday, 25 January 2002 11:11:06 a.
To: Barry Rumsey
Cc: roxen@roxen.com
Subject: Re: Count(*)
Barry Rumsey wrote:
> I have this small query on a page:<emit source="sql" host=xoops query=
> SELECT COUNT(*) FROM xp_topics WHERE artist='artist' ORDER BY topicid DESC
> LIMIT 1">&sql.artist;</emit>
Use "SELECT COUNT(*) AS C FROM ..." instead. Then you can access the
count value as &sql.c;
Kai
--
dreiecksplatz 8, d-24105 kiel, +49-431-22199869, http://k.123.org/
.