[plug] Optimise MySQL query

nigel at dubh.id.au nigel at dubh.id.au
Wed Mar 29 11:01:42 WST 2006


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





More information about the plug mailing list