findet den vielelciht wer?
Code: Alles auswählen
/
$cat_id = $_POST['c'] ? $_POST['c'] : ( $_GET['c'] ? $_GET['c'] : 0 );
$cat_where = "cat_parent = $cat_id";
if ($cat_id != 0)
{
$sql = "SELECT c.*, COUNT(p.pic_id) AS count
FROM ". ALBUM_CAT_TABLE ." AS c
LEFT JOIN ". ALBUM_TABLE ." AS p ON c.cat_id = p.pic_cat_id
WHERE $cat_where
if ( $result = $db->sql_query($sql) )
{
$row = $db->sql_fetchrow($result);
$template->assign_vars(array(
'SUBCAT_NAV' => "-> <a class=\"nav\" href=\"album.$phpEx?c=" . $row['cat_id'] . "\">" . $row['cat_title'] . "</a>",
)
);
}
}
$sql = "SELECT c.*, COUNT(p.pic_id) AS count
FROM ". ALBUM_CAT_TABLE ." AS c
LEFT JOIN ". ALBUM_TABLE ." AS p ON c.cat_id = p.pic_cat_id
WHERE cat_id <> 0
GROUP BY cat_id
ORDER BY cat_order ASC";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
$catrows = array();
