Thank you everyone. The "COUNT(*) AS c" worked great.
-------Original Message-------
From: Kai Voigt
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;


dreiecksplatz 8, d-24105 kiel, +49-431-22199869,

  IncrediMail - Email has finally evolved - Click Here

Reply via email to