1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
// CATEGORIES SELECTION START
$sql = "SELECT cat_id, cat_name, cat_owner, cat_status FROM categories WHERE cat_status=1 ORDER BY cat_name";
$categories_query = $db->sql_query($sql);
$categories_array = array();
while ($categories = mysql_fetch_object($categories_query))
{
$sql_entries = "SELECT COUNT(*) FROM sub_categories WHERE sub_cat_main=".$categories->cat_id;
$sql2 = mysql_query($sql_entries);
$cat_entries = mysql_fetch_array($sql2);
$categories_array[] = array(cat_id => $categories->cat_id,
cat_name => $categories->cat_name,
cat_entries => $cat_entries->cat_entries);
}
$smarty->assign('categories',$categories_array);
// CATEGORIES SELECTION END |
Partager