[MySQL] Count dans boucle

Count dans boucle

Bonjour,

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
// 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;
	echo $sql_entries;
	$cat_entries = mysql_fetch_array($sql_entries);
 
	$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

Pouvez vous m'aider svp ?

J'ai l'erreur Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

Salut,

normal, tu n'exécutes pas la requêtes dans ta boucle ...

Code:

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

ah oui, merci