curdate() Order by noticiadata DESC", $dbh); //echo ''; while ($myrow = mysql_fetch_array($result)) { echo "
".substr($myrow['noticiadata'],8,2)."/".substr($myrow['noticiadata'],5,2)."/".substr($myrow['noticiadata'],0,4)." ".$myrow["tituloptg"]; } //echo ''; ?>