CODE (text):
скопировать код в буфер обмена
скопировать код в буфер обмена
- $db_res = db_query("SELECT id FROM orders WHERE shop_id = 1 GROUP BY id ");
- for($mass_orders = array(); $row = mysql_fetch_assoc($db_res); $mass_orders[] = $row);
- $sum = 0;
- $punct = 0;
- // начало цикла
- for($i = 0; $i<count($mass_orders); $i++) {
- $res = $mass_orders[$i]["id"];
- $db_res = db_query("SELECT DISTINCT provider FROM orders_product WHERE orders_id = ".$res." ORDER BY provider");
- $sum = mysql_num_rows($db_res);
- if ($sum != 0) $sum = $sum+1;
- $punct = $punct+$sum;