Вот мой скрипт отображения категорий:
function print_cats_8() {
$qq = "
";
$query = "SELECT * FROM `cat` WHERE `name` BETWEEN \'П%\' AND \'С%\' ORDER by name;";
// $query = "SELECT * FROM `refs` WHERE `cat_id` =33 AND `scat_id` =24 AND `type_id` =2;";
$rez = sql_query($query);
while (list ($id, $name) = mysql_fetch_array($rez)) {
$query2 = "SELECT * FROM scat WHERE cat_id=\'".$id."\' ORDER by name;";
$rez2 = sql_query($query2);
if (mysql_num_rows($rez2) != 0) {
$qq .= "+ ";
$qq .= "-";
$app_1 = "onclick=\\"return displayNews5(".$id.");\\" ";
$app_2 = "onclick=\\"cache(\'a1\'); cache(\'t2\'); montre(\'t1\'); return displayNews5(".$id.");\\" ";
} else {
$qq .= " ";
$qq .= "-";
$app_1 = "";
$app_2 = "";
}
$qq .= " ".$name."
\\n";
// $qq .= " ".$name."
\\n";
if (mysql_num_rows($rez2) != 0) {
// $qq .= " Разделы
//\\n";
$qq .= "\\n";
while( list ($id2, $cat_id, $name2) = mysql_fetch_array($rez2)) {
$qq .= "
".$name2."\\n";
}
$qq .="
\\n";
}
}
return $qq;
}