Comparing Dates

saeed42

I'm trying to have a gif that says "NEW" next to the recently submitted articles which might be less than 7 days old, so my questions how do I compare the date in the db which is in Ydm format to today's date and if the difference is less than 7 days to show the gif and if more than 7 days not to show anything

$today = date(Ymd);

if(($sub_date+7) < $today) 
	{
	include("new.gif"); 
	}

LordShryku

Best to make them time comparisons

$sevenDaysAgo = mktime(0,0,0,date("m"), date("d")-7, date("Y"));
$fromDb = strtotime($sub_date);
// Now perform comparison

superwormy

Yes, convert them to UNIX TIMESTAMPS with strtotime() ( www.php.net/strtotime ) before comparing. Compare in seconds!

saeed42

Thanks for your prompt replies guys, all is well now, and I decided to post the code just in case another newbie like myself finds it useful

<td><?php echo $row_rsIndepth['Subject']; ?>

<?php 
//Workout the date in order to display new.gif if article is less than 7 days old

$subdate = $row_rsIndepth['SubDate'];
$tstamp = strtotime($subdate); 
$sevenDaysAgo = mktime(0,0,0,date("m"), date("d")-7, date("Y")); 

if($sevenDaysAgo < $tstamp) 
		{?>
	<img src="/Images/new_1.gif" align="absmiddle"> 
		<? } ?> </td>