[thelist] php/mysql: fetch records posted this week and add values
Dan Duris
dusoft at staznosti.sk
Tue Oct 21 16:39:24 CDT 2003
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 -*
More information about the thelist
mailing list