Posted by Justin Koivisto on 01/11/06 16:10

frizzle wrote:
> Jaak wrote:
>
>>I have this query, it gives the suspected information in myphpadmin:
>>
>>select listid, count(*) from table1 group by listid
>>
>>How do I put this the result into an array in php? I have problems with the
>>count(*) field
>
>
> you could create an alias,
> COUNT(*) AS 'number_of_countings'
>
> and later call it as $query['number_of_countings']

heh - I missed this thread in here, but picked up on it in a.c.d.mysql...

--
Justin Koivisto, ZCE - justin@koivi.com
http://koivi.com

[Back to original message]