[plug] Optimise MySQL query

[nigel at dubh.id.au]

Hi Ryan,

On Wed, Mar 29, 2006 at 10:40:56AM +0800, Ryan King wrote:
> 
> SELECT count(*), DATE_FORMAT(date, '%Y-%m') as month
> FROM $table
> WHERE user=$user
> GROUP BY month

Thanks, just what I needed. 

I was hoping I wouldn't be the one that does the database work
but it looks like I am going to have learn it. Are there any good
books you would recommend on the subject or is the mysql
online documentation sufficient?

Thanks again.

Nigel