Код: Выделить всё
Could not query categories list
DEBUG MODE
SQL Error : Error
SELECT c.*, COUNT(p.pic_id) AS count FROM phpbb_album_cat AS c LEFT
JOIN phpbb_album AS p ON c.cat_id = p.pic_cat_id WHERE cat_id <> 0
GROUP BY cat_id ORDER BY cat_order ASC
Код: Выделить всё
$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";