<html>
<head>

<title>andrew_des</title>
<link href= "css/style.css" rel= "stylesheet" type= "text/css">
<meta charset="utf-8">
</head>
<body>
<div class="wrap_all">
<div class="banner"><?php include('template/banner.php')?>
</div>
<div class="content">
<div class="php">
<?php

include ('connect.php');

$comando = "select * from users where mestiere='falegname'"; // ---------------al posto del * inserire sole le categorie di interesse, es. Tel Cell, email etc quindi $comando = "select id, Tel Cell,email from users";
// a questo punto avremo visualizzati solo le categorie che abbiamo deciso e non tutte


$result=mysql_query($comando);
//$result=mysql_query("select * from users where mestiere='falegname'");

echo "<table border='1'>";

echo "<tr> <td colspan='5' style='text-align:center; color: red;'>CONTATTI</td></tr>";

echo "<tr style='font-weight:bold; color: blu;'>",
"<td>id</td><td>Ragione_Sociale</td>",
"<td>Telefono</td> <td>email</td> <td>mestiere</td>",
"</tr> \n";


while ($dati =mysql_fetch_assoc($result))

{ echo "<tr>";

print "<td> $dati[id]</td>";
print "<td> $dati[Ragione_Sociale]</td>";
print "<td> $dati[Telefono]</td>";
print "<td> $dati[email]</td>";
print "<td> $dati[mestiere]</td>";

echo "</tr> \n";
}

echo "<tr> <td colspan='5'>---------------------------------------------------------------------</td></tr>";
$result=mysql_query($comando);


?>


</div>

</div>
<div class="footer"><?php include('template/footer.php')?>
</div>
</div>


</body>
</html>