I have a post table that has some of these fields:
i want to query the number of posts that happened in the last 30 days and display the date.i.e display posts that happened on each date and the also display the date.
EG:
NO DATE
POSTS 10 1/9/2011
POSTS 20 31/8/2011
i know i can do a select postid and then do a mysql_num_rows to get the number of posts. But I am not sure how to get the result of last 30 days and display that date. Here is my table structure
postid username userid title dateline
1 test 3 member 1186945212
3 tester 5 JM 1187106827
i want to query the number of posts that happened in the last 30 days and display the date.i.e display posts that happened on each date and the also display the date.
EG:
NO DATE
POSTS 10 1/9/2011
POSTS 20 31/8/2011
i know i can do a select postid and then do a mysql_num_rows to get the number of posts. But I am not sure how to get the result of last 30 days and display that date. Here is my table structure
postid username userid title dateline
1 test 3 member 1186945212
3 tester 5 JM 1187106827
Comment