|
Thank you everyone. The "COUNT(*) AS c" worked great.
-------Original Message-------
Date: Friday, 25
January 2002 11:11:06 a.
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/
. |
