This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
June 30, 2012 3:32am
Subscribe [2]#1 / Jun 30, 2012 3:32am
Hi folks
Is there a way to get a list of all forum-threads initially posted or answered in the last 7 Days?
It does not have to be super-fast/performant — It’s for analytics and therefore the script does run only once each week. It’s also on a MSM and therefore on a second site (the forum is on Page 1, the analytics-site is on Page 2).
Any Ideas?
#2 / Jun 30, 2012 9:33am
Query module maybe?
http://ellislab.com/expressionengine/user-guide//modules/query/index.html
#3 / Jun 30, 2012 9:53am
Thx Ieeaston. Btw: Did I forgot to mention that I cant write PHP and/or MySQL? 😉
#4 / Jun 30, 2012 10:07am
MySQL is quite easy to understand and use in EE. I’d highly recommend getting this book, it’s written for non geeks and is easy to follow. I’ve managed to get EE to do a lot of things it doesn’t do out the box in just a few lines of SQL.
For a good intro on how to use the query module I’d recommend you get this video:
http://mijingo.com/products/screencasts/mysql-and-expressionengine/
You won’t look back…