Posted by frizzle on 01/11/06 02:50

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']

[Back to original message]