[T3MEDIA]

This code used to go into vbindex... anyone know the proper sql query I should use for the new version?

PHP Code:

$getlateste= $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 AS journal_entries 
            LEFT JOIN ".TABLE_PREFIX."journals AS journals ON (journal_entries.journal_id=journals.journal_id) 
            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 AND journals.private!=1 
            ORDER BY journal_entries.entrydate DESC
            LIMIT 5
            ");
            $countlatest= $DB_site->num_rows($getlateste);
            $latestentrybits = "";
            if($countlatest>0)
            {
                while($latest= $DB_site->fetch_array($getlateste))
                {
                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);
                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);
                    exec_switch_bg();
                    if(strlen($latest[entrytitle])>20)
                    {
                        $latest[entrytitle]= "".substr($latest[entrytitle],0,20)."...";
                    }
                    if(strlen($latest[entrytext])>150)
                    {
                        $latest[entrytext]= "".substr($latest[entrytext],0,150)."...";
                    }
                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');
                }
                $DB_site->free_result($lastest);
            }
            else
            {
                $latestentrybits="There are no entries.";
            } 


Anyone else having IMG issues with this version?