";
}
$rst_day = mysql_query("SELECT DISTINCT FROM_UNIXTIME(n.created, '%D') as the_day FROM node n, term_node tn, term_data td WHERE FROM_UNIXTIME(n.created, '%Y')='".$row['the_year']."' AND n.nid = tn.nid and tn.tid = td.tid and td.name in ('News','Future','Family') and td.vid = '6' AND FROM_UNIXTIME(n.created, '%M')='".$row_month['the_month']."' ORDER BY n.created DESC");
while($row_day = mysql_fetch_array($rst_day))
{
$rst_news = mysql_query("SELECT * FROM node n, term_node tn, term_data td WHERE FROM_UNIXTIME(n.created, '%D')='".$row_day['the_day']."' AND FROM_UNIXTIME(n.created, '%M')='".$row_month['the_month']."' AND n.nid = tn.nid and tn.tid = td.tid and td.name in ('News','Future','Family') and td.vid = '6' AND FROM_UNIXTIME(n.created, '%Y')='".$row['the_year']."'");
while($row_news=mysql_fetch_array($rst_news))
{
//$news_title = str_replace("'", "'", $row_news['title']);
$news_title = htmlspecialchars($row_news['title'],ENT_QUOTES);
$news_id = $row_news['nid'];
$news_count ++;
echo "
". $row_day['the_day'] ." - ". $news_title ."";
echo "
";
echo "
";
echo "Close [X]";
echo "
";
$news_node = node_load($news_id);
if($news_node->title)
{
echo "
". $news_node->title ."
";
}
if($news_node->field_headline_0[0]['value'])
{
echo "
". $news_node->field_body_0[0]['value'] ."
";
}
if($news_node->field_summary_description[0]['value'])
{
echo "
". $news_node->field_summary_description[0]['value'] ."
";
}
if($readmore==1)
{
echo "
read more
";
}
echo "
";
echo "Close [X]";
echo "
";
echo "
\n";
}
}
echo "