ok its getting all the information its susposed to but then its not displaying it
heres my code:
PHP Code:
$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.";
}
and
here is how it appears in the template:
HTML Code:
<table class="tborder" cellspacing="$stylevar[cellspacing]" cellpadding="$stylevar[cellpadding]" border="0" align="center" width="100%">
$latestentrybits
</table>
the table its self doesnt even show up