Lettura ultimo record

[poeta1978]

<table width="100%" border="0" bgcolor="#FFCC66">
<?
$query = "SELECT ID,Data FROM notizie ORDER BY ID DESC";
$result = mysql_query($query, $db);
?>
<tr>
<td>News --- <? echo $row["Data"] ?></td>
</tr>
</table>

Col codice sopra vorrei leggere l'ultima data, ma non mi dà niente, perché?

[kuba]

mysql_fetch_array...?

[poeta1978]

<?
$query = "SELECT ID,Data FROM notizie ORDER BY ID DESC";
$result = mysql_query($query, $db);
mysql_fetch_array($result);
?>
<tr>
<td>News --- <? echo $row["Data"] ?></td>
</tr>
</table>

Così?

[piero.mac]

Originariamente inviato da poeta1978
<?
$query = "SELECT ID,Data FROM notizie ORDER BY ID DESC";
$result = mysql_query($query, $db);
mysql_fetch_array($result);
?>
<tr>
<td>News --- <? echo $row["Data"] ?></td>
</tr>
</table>

Così?

$row = mysql_fetch_array($result);

[poeta1978]

Grazie!

[bubu sette sette]

Se devi selezionare solo un record
SELECT ID,Data FROM notizie ORDER BY ID DESC LIMIT 0,1

altrimenti ti carica tutta la tabella sprecando memoria