1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| <?php
$req2 = "select count(lieu_type) as nombre, lieu_type
from annonce
group by lieu_type";
$res2 = mysql_query($req2);
$nbr2 = mysql_num_rows($res2);
if($nbr2 != 0)
{
?>
<table border width="80%" align="center" BGCOLOR="white" BORDERCOLOR="#AODOFF" CELLPADDING=5 CELLSPACING=0>
<tr>
<td>
<table border=0 width="80%" align="center" BGCOLOR="white" BORDERCOLOR="#AODOFF" CELLPADDING=5 CELLSPACING=0>
<?php
while($row2 = mysql_fetch_assoc($res2))
{
?>
<tr>
<td><?php echo $row2["lieu_type"]." (".$row2["nombre"].")"?></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table> |
Partager