How to display message to users who registered within last 7 days?

[paperweight]

I am playing around with some code, but there is something missing. I think it may be the strtotime for Smarty that I researched, but I'm still unclear. I am now looking at the tblclients and trying to get the datecreated to work from "today"s date", etc. and then seeing if it is less than 8 days old.

 

Here is the basic code below and I know there are large gaps , but I need assistance and advice on how to integrate the strtotime (if necessary) into this.

 

 

<!-- BEGIN TO CHECK IF USER IS NEW OR NOT (If they signed up within the last 7 days) -->
{php}
// take the user's id
$userID = $_SESSION["uid"];
// try to find that user among tblclients to see if they have registered in the last 7 days	
$sql = "SELECT id FROM tblclients WHERE datecreated = ".$userID;
$result = mysql_query($sql);
$rows = mysql_num_rows($result);
// if found
if ($rows < 
{
	$this->assign('isNewClient',"Y");
}
// if not
else
{
	$this->assign('isNewClient',"N");
}
{/php}
<!-- END TO CHECK IF USER IS NEW OR NOT (If they signed up within the last 7 days)  -->