$getlatest= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_id, journal_entries.entrytext,journal_entries.journal_id,journals.journalist,journals.journalist_id FROM ".TABLE_PREFIX."journal_entries LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 ORDER BY journal_entries.entrydate DESC "); $countlatest= $DB_site->num_rows($getlatest); if($countlatest>0) { while($latest= $DB_site->fetch_array($getlatest)) { $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1); $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']); exec_switch_bg(); eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";'); } } else { $latestentrybits="There are no entries."; }
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%"> $latestentrybits </table>