| |
 5.6 Кб |
|
| | Добрый день!
Помогите, пожалуйста, упростить данный код...
$query_cat = "SELECT * FROM realty_category where subcategory='0' order by id";
$numcat = mysql_query($query_cat) or die("Error:<b> ". mysql_error()." </b>in file <b>".__FILE__."</b> on line <b>".__LINE__);
if (mysql_num_rows($numcat)!=0)
{
echo "<table width=\"100%\">\n";
$final = 0;
while($cat = mysql_fetch_array($numcat))
{
$query_subcat = "SELECT * FROM realty_category where subcategory='$cat[id]' order by id";
$numsubcat = mysql_query($query_subcat) or die("Error:<b> ". mysql_error()." </b>in file <b>".__FILE__."</b> on line <b>".__LINE__);
if (mysql_num_rows($numsubcat)!=0)
{
if($final == 0) echo "<tr>";
echo "<td>\n<table>\n<tr>\n<td>\n<b>".$cat["title"]."</b></td>\n</tr>\n";
$bg[1]="#FFFFFF";
$bg[0]="#CCCCCC";
$nbg=0;
while($subcat = mysql_fetch_array($numsubcat))
{
$query_subtitle = "SELECT * FROM realty_category where subcategory='$subcat[id]'";
$numsubtitle = mysql_query($query_subtitle) or die("Error:<b> ". mysql_error()." </b>in file <b>".__FILE__."</b> on line <b>".__LINE__);
echo "<tr bgcolor=\"".$bg[$nbg]."\">\n<td>".$subcat["title"]."";
while($subtitle = mysql_fetch_array($numsubtitle))
{
echo " ".$subtitle["title"].", ";
}
$nbg = ($nbg == 0) ? 1 : 0;
echo "</td>\n<td>кол-во</td>\n</tr>\n";
}
echo "</table>\n</td>";
}
$final++;
if($final == 2)
{
echo "\n</tr>";
$final = 0;
}
}
echo "</table>";
}
|
Заранее спасибо. Дамп таблиц во вложении. | |
| |
|
