[SOLVED] Determining Date Passage

[smc]

Hello everyone,

 

Basically I want to add code that will allow me to only fetch articles from the database that are only as old as 6 months ago. Unfortunatly I'm not really sure where to get started. I know my way around PHP so if you put me on the right track I should be good.

 

Thanks!!

[boo_lolly]

i'd start by adding a column to my database table that is used to store the date when the article was published/uploaded.

[smc]

That's already done but the question is how to tell if it's been 6 months

[redarrow]

if it in a timestamp method this should work

<?php

$months_ago=time()-15778463;

$query="SELECT * from what_ever where your_date<$months_ago";

?>

[akitchin]

i personally maintain the principle that one should use MySQL to its full advantage.  that being said, you can simply run a query like so:

 

SELECT stuff FROM table WHERE date_column >= DATE_SUB(NOW(), INTERVAL 6 MONTH)

 

have a look at MySQL's built-in functions, they have a fair number of especially useful ones.

[redarrow]

http://www.phpfreaks.com/forums/index.php/topic,130186.0.html

 

read this post for study reasons

[smc]

Excellent, perfect.

 

Thanks for all your help