<?php
defined( '_VALID_LM' ) or die( 'Direct Access to this location is not allowed.' );
global $conn;
$rs = $conn->Execute("SELECT news FROM #__newsflash WHERE published = 1 ");
if( $rs && $rnum=$rs->RecordCount()>0 && $rsa=$rs->GetArray() )
{
$randflash=rand(0,$rnum);
$row = $rsa[$randflash];
echo dbdecode($row['news']);
} 
?>