lister wrote:
>> You need to add a "group by " to your statement (like the error message
>> tells you).
>
> But I don't want it grouped by anything. I just want the normal result
> set.
>
>
that will be the normal result set. for mysql to calculate the count it
needs to group by the column you're selecting so something like this
will do it for you:

SELECT productname, COUNT(*) AS cnt from URL group by productname

--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".