[thelist] php/mysql: fetch records posted this week and add values

Dunstan Orchard dunstan at 1976design.com
Tue Oct 21 14:43:06 CDT 2003


Hi there,

Just my luck, the day rudy decides to leave I get another MYSQL problem :o)

Can anyone suggest how I can do the following:

I need to write a query which selects only the records whose blog_date value
falls in this week.
I then need to get the sum of all the values of blog_num for those records.

For example:

TABLE blog (
  blog_date date NOT NULL default '0000-00-00',
  blog_num tinyint(4) NOT NULL default '0'
) TYPE=MyISAM;

2003-11-15  23
2003-11-28  36
2003-12-08  16
2003-12-18  19
2003-12-20  35
2003-12-21  27

The query would bring back:

2003-12-20  35
2003-12-21  27

And then return the sum:

62

Can anyone help? I'm stumped :o(

Thanks very much - Dunstan

---------------------------
Dorset, England
http://www.1976design.com/
http://www.1976design.com/blog/


More information about the thelist mailing list