<table align="center" width="100%">
<?php
include('config.php');
$query="SELECT Nome, Cognome, Indirizzo, Citta, CAP, Provincia from anagrafe_privati order by Id";
$result= mysql_query($query);
$numfields = mysql_num_fields($result);
$numrecord = mysql_num_rows($result);
$row = mysql_fetch_array ($result, MYSQL_ASSOC);

echo "<tr>\n";
echo "<th>Nome</th>";
echo "<th>Cognome</th>";
echo "<th>Indirizzo</th>";
echo "<th>Citt&agrave;</th>";
echo "<th>CAP</th>";
echo "<th>Provincia</th>";
echo"<tr>\n"; echo"</tr>\n";
echo"</tr>\n";
for ($i = 0; $i < $numrecord; $i++)
{
$query="SELECT Nome, Cognome, Indirizzo, Citta, CAP, Provincia from anagrafe_privati order by Id LIMIT $i,$numrecord";
$result= mysql_query($query);
$row = mysql_fetch_array ($result,MYSQL_ASSOC);

echo"<tr>\n";
echo"<td>".$row['Nome']."</td>";
echo"<td>".$row['Cognome']."</td>";
echo"<td>".$row['Indirizzo']."</td>";
echo"<td>".$row['Citta']."</td>";
echo"<td>".$row['CAP']."</td>";
echo"<td>".$row['Provincia']."</td>";
echo"<td>".""."[img]../../img/pin.png[/img]".""."</td>";
echo"</tr>\n";
}
?>
</table>