$sql = "SELECT * FROM newsitems order by releasedate desc";
mysql_connect();
$rs = mysql_DB_query("newsdb", $sql);
while($row = mysql_fetch_object($rs))
{
//$val = getdate();
$curr_date = date("Y-m-d");
//$curr_date = getdate();
$title = $row->title;
$author = $row->author;
$body = $row->body;
$date = $row->releasedate;
$link = $row->link;
//echo "Current date: $curr_date News Date: $date ";
$newsplit = explode("-", $date);
$currsplit = explode("-", $curr_date);
$curr_time = mktime(0,0,0,$currsplit[1], $currsplit[2], $currsplit[0]);
$news_time = mktime(0,0,0,$newsplit[1],$newsplit[2],$newsplit[0])+ (86400*30);
//echo "Current time: $curr_time News Time(30 days): $news_time";
//if(($val[mon] == $newsplit[1]) && ($val[year] == $newsplit[0]))
if(($news_time > $curr_time) && ($currsplit[0] == $newsplit[0]))
{
echo (" ");
echo ("");
printf("%s", $title);
echo(" ");
printf("%s - Date: %s/%s/%s ", $author, $newsplit[1], $newsplit[2], $newsplit[0]);
echo("  ");
printf("%s ", $body);
echo("
");
printf("To read more click here.", $link);
echo(" ");
}
}
?> |