include 'admin/conecta.php';
$noticias= mysql_query("select *, DATE_FORMAT(data,'%d/%m/%Y') as data from a_na_midia order by data ") or die(mysql_error());
$i=0;
while ($i < mysql_num_rows($noticias))
{
$lista=mysql_fetch_array($noticias);
$texto=strip_tags($lista['texto']);
$texto = substr($texto, 0, 330);
echo "-
".$lista['data']." - ".$lista['titulo']." ".$texto."...
";
$i++;
}
mysql_close();
?>