mostrar los 10 ultimos datos de una tabla

[Mirovita]

$query="SELECT * FROM datos10min ORDER BY date_time DESC LIMIT 0, 10"; //10 ultimos registros

$result=pg_Exec($conn,$query);

if ($row=pg_fetch_array($result))

{

echo"<TABLE width='1000' BORDER=5 CELLPADDING=1 CELLSPACING=1 bordercolor='#003399'>";


echo" <tr><td><div align='center'><span class='style1'>data_time</span></div></td><td><div align='center'><span class='style1'>latitude</span></div></td><td><div align='center'><span class='style1'>latitude_sing</span></div></td><td><div align='center'><span class='style1'>longitude</span></div></td><td><div align='center'><span class='style1'>longitude_sing</span></div></td></tr>";


do
{


printf("<tr><td><div align='center'><span class='style3'>%s</span></div></td><td><div align='center'><span class='style3'>%s</span></div></td><td><div align='center'><span class='style3'>%s</span></div></td><td><div align='center'><span class='style3'>%s</span></div></td><td><div align='center'><span class='style3'>%s</span></div></td></tr>",$row["date_time"], $row["latitude"], $row["latitude_sign"], $row["longitude"], $row["longitude_sign"]);

}
while($row=pg_fetch_array($result));

echo" </TABLE>";
}
else
{
echo "<div align='center'><h4 class='style2'>&iexcl; No se ha encontrado ning&uacute;n dato !</h4></div>";
}