Compare current date with the date in database

[lukelee]

Hi, Currently I am making a module for joomla. every article has an publish date, if the article was published in 7 days ago, it will displayed as "article in last week", My idea is to use today's date - publish date, if the result is greater than 7 and smaller than 14, the article will be displayed as "article in last week.

Any one know how to write this code?

Here is what I have got, but not working.

<?php
$todays_date = date("Y-m-d"); 

$result = mysql_query("select * from jos_content where $test between $todays_date-14 and $todays_date-7");  
while($row = mysql_fetch_array($result))
  {
echo "$todays_date - $row[title]";
}
?>

[abdfahim]

Use your SQL QUERY like

$result = mysql_query("select * from jos_content where DATEDIFF(publish_date,'".$todays_date."') between 7 AND 14);  

[lukelee]

ah, it works, thanks man.

What if I want to display the articles before 7days? can I write :" between 7 AND 100000"