Dovrebbe assomigliare a questo....


codice:
include("connessione.inc.php");
$query = "SELECT foto, data, id, categoria, codice, descrizione, prezzo, note FROM offerte ORDER BY id DESC LIMIT 5";
$result = mysql_query($query, $db); 
echo "<table width=\"412\" border=\"1\">";
while ($row = mysql_fetch_array($result)) {
echo "<tr> 
<th width=\"149\" height=\"34\" bordercolor=\"#0066FF\" scope=\"row\">Offerta n:</th> 
<td width=\"253\">$row[id]</td> 
</tr>
<tr> 
<th height=\"31\" scope=\"row\">Foto</th> 
<td>$row[foto]</td> 
</tr>

<tr> 
<th height=\"21\" scope=\"row\">Nome lotto/Codice</th> 
<td>$row[codice]</td> 
</tr>

<tr> 
<th height=\"21\" scope=\"row\">Categoria</th> 
<td>$row[categoria]</td> 
</tr>

<tr> 
<th height=\"33\" scope=\"row\">Descrizione</th> 
<td>$row[descrizione]</td> 
</tr>

<tr> 
<th height=\"23\" scope=\"row\">Prezzo</th> 
<td>€ $row[prezzo]</td> 
</tr>

<tr> 
<th height=\"21\" scope=\"row\">Note : </th> 
<td>$row[note]</td> 
</tr>

<tr> 
<th height=\"33\" scope=\"row\">Data inserzione :</th> 
<td>$row[data]</td> 
</tr>";
}

echo "</table>";