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

[Dan Duris]

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

SELECT SUM(blog_num) FROM blog WHERE blog_date='YYYY-MM-DD';


dan
--------------------------
email: dusoft at staznosti.sk
ICQ: 17932727

*- do you like old games? try: www.the-underdogs.org -*