$query = mysql_query("SELECT DISTINCT(`user_id`) FROM `order`");
While($row = mysql_fetch_array($query)){
$queryy = mysql_query("SELECT COUNT(`order_id`) AS `order_id`,`name`, SUM(`total`)AS `total` FROM `order` WHERE `user_id`='".$row['user_id']."'");
$rows = mysql_fetch_array($queryy);
echo $rows['name'];
echo $rows['order_id'];
echo $rows['total']/$rows['order_id'];
echo $rows['total'];
}
No comments:
Post a Comment