';
$prevRes=dosql("SELECT id FROM news WHERE isPublished=1 AND newsDate<'".$record->newsdate."' ORDER BY newsdate DESC LIMIT 0,1" );
if ($prevRec=mysql_fetch_object($prevRes))
{
if ($prevRec->id>0)
{
echo '
';
}
}
$nextRes=dosql("SELECT id FROM news WHERE isPublished=1 AND newsDate>'".$record->newsdate."' ORDER BY newsdate ASC LIMIT 0,1" );
if ($nextRec=mysql_fetch_object($nextRes))
{
if ($nextRec->id>0)
{
echo '
Het nieuws van '.$months[$month].' van Experience Center Rosmalen
';
} else {
echo '
Blijf op de hoogte van de ontwikkelingen
';
}
echo '
';
if ($month>0)
{
$itemspp=40;
$limit='';
$where=" WHERE MONTH(newsDate)=$month AND isPublished=1 ";
} else {
$itemspp=4;
$limit="LIMIT $offset,$itemspp";
$where=' WHERE isPublished=1 ';
}
if ($year > 0)
{
$where.=" AND YEAR(newsDate)=$year ";
}
$countResult=dosql("SELECT COUNT(*) AS nritems FROM news $where ");
$countRecord=mysql_fetch_object($countResult);
$nritems=$countRecord->nritems;
$result=dosql("SELECT * FROM news $where ORDER BY newsDate DESC $limit ");
while ($record=mysql_fetch_object($result))
{
//check for images
$thumb=false;
$AgetHeaders = get_headers('http://ecr.born05.nl/images/news/'.$record->id.'.jpg');
if (preg_match("|200|", $AgetHeaders[0]))
{
echo '
';
}
echo ''.$record->teaser.'';
echo '
meer';
if ($thumb)
{
echo '
vorige pagina