|
|
|
| HelLO!
RUSSKOY KLAVI NET RYDOM POETOME TAK PISHU
kak ubrat pustishki iz koda?
<?php
$sql = mysql_query("SELECT * FROM town ORDER by name");
if(!$sql)
{echo "<br><p>В данном разделе пока нет информации</p>";}
else
{
if(mysql_num_rows($sql) > 0)
{
while ($row = mysql_fetch_array($sql))
{
$query = "SELECT COUNT(*) FROM pu
WHERE approved='1' and id_town='$row[id_town]'";
$res = mysql_query($query);
if(!$res) exit("<br>Ошибка обращения к базе данных - ".mysql_error());
$total = mysql_result($res, 0);
if($total > 0)
{
$filename[] = "<a href='post_towns_pu.php?id_town=$row[id_town]'>$row[name]</a> ($total)";
}
}
}
}
?>
|
| |
|
|