Calling things only from X time ago and after

[smc]

Hello everyone,

 

I asked this question before and I thought I got it but it ended up not working.

 

Basically I am trying to call articles from my database that are at maximum as old as 6 months and then after.

 

Here is what was originally suggested but didn't work out:

 

AND date >= DATE_SUB(NOW(), INTERVAL 6 MONTH)

 

If you have any ideas I would be much appreciated!

 

Note: my dates are stored in the NOW() time code format

[per1os]

SQL is great, but why not use PHP to get your date manipulation?

 

As such

 

<?php
$sixMonths = (time()+60*60*24*60); // time six months from now

$sql = "SELECT * FROM articles WHERE articledate > " . $sixMonths;
mysql_query($sql);
?>

 

--FrosT

[smc]

Well the problem with that is that in my database its formated as 2007-03-09 20:00

[redarrow]

done it sir anythink else sir.

 

<?php
$sixMonths = (time()+60*60*24*60); // time six months from now
$sixMonths=date("Y-m-d h:i",$sixMonths);
$sql = "SELECT * FROM articles WHERE articledate > " . $sixMonths;
mysql_query($sql);
?>

[per1os]

Use the date function http://us2.php.net/manual/en/function.date.php to format it that way:

 

<?php
$sixMonths = date('Y-m-d G:i', (time()+60*60*24*60)); // time six months from now

$sql = "SELECT * FROM articles WHERE articledate > " . $sixMonths;
mysql_query($sql);
?>

 

--FrosT