$result = mysql_query("UPDATE categories SET product_count = '$next_links', product_count_admin = '$next_links' WHERE categoryID = '$min_categoryID' ");
list($sum) = mysql_fetch_array(mysql_query("SELECT SUM(products_count) FROM categories WHERE categoryID>'$min_categoryID' AND categoryID<='$max_categoryID' "), MYSQL_NUM);
echo $sum;
list($num) = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM имя_таблицы_2"), MYSQL_NUM);
echo $num;
mysql_query("UPDATE categories SET product_count = '$num', product_count_admin = '$num' WHERE categoryID = 'номер_главной_категории' ")
list($num) = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM имя_таблицы_2 WHERE categoryID>'$min_categoryID' AND categoryID<='$max_categoryID' "), MYSQL_NUM);
$result = mysql_query("SELECT categoryID, COUNT(*) AS next_links FROM имя_таблицы_2 GROUP BY categoryID");
while(list($categoryID, $next_links) = mysql_fetch_array($result, MYSQL_NUM))
mysql_query("UPDATE categories SET product_count = '$next_links', product_count_admin = '$next_links' WHERE categoryID='$categoryID' ");
$row = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM имя_таблицы_2"), MYSQL_NUM);
echo $row[0];
$result = mysql_query("SELECT categoryID, COUNT(*) AS next_links FROM имя_таблицы_2 GROUP BY categoryID");
while($row = mysql_fetch_array($result, MYSQL_NUM))
mysql_query("UPDATE categories SET product_count = '$row[1]', product_count_admin = '$row[1]' WHERE categoryID='$row[0]' ");
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.