Okay...I am making progress with my forum script/add-on. I am trying to show posts in the last 24, 48, 72 hours...I've been playing around with the DATE_ADD MySQL function, which is referenced here:
http://www.mysql.com/..._time_functions.html
(Although the examples given in this page are not that great since they simply use the SELECT statement within a table, which does not include JOINS or FROM.)
I am using the following codes in my forum script:
I have also tried using the MySQL example of "-1, $postdays", before the INTERVAL attribute.
But no matter what parameter value I add, like 144 or any other integer/numerical value, all posts show up.
Any ideas or directions would be helpful!
Thanks in advance!
Regards,
Regards,
Eliot Lee
http://www.mysql.com/..._time_functions.html
(Although the examples given in this page are not that great since they simply use the SELECT statement within a table, which does not include JOINS or FROM.)
I am using the following codes in my forum script:
I have also tried using the MySQL example of "-1, $postdays", before the INTERVAL attribute.
But no matter what parameter value I add, like 144 or any other integer/numerical value, all posts show up.
Any ideas or directions would be helpful!
Thanks in advance!
Regards,
Regards,
Eliot Lee