[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