$kategoriler = mssql_query("select (select count(product_id)from products where products.anakategori=category.category_id) as urunsayisi,
category.category_name, category.link,category.ust, category.category_id from category left join products on (products.category_id=category.category_id)
where category.ust='0' ");Arkadaşlar gruplama yapmam lazım ama yazdıgım kod çalışmıyor.
$kategoriler = mssql_query("select (select count(product_id)from products where products.anakategori=category.category_id) as urunsayisi,
category.category_name, category.link,category.ust, category.category_id from category
left join products on (products.category_id=category.category_id)
where category.ust='0' GROUP BY category_id");sizce nasıl olmalıdır ?