Powered By Blogger

Friday, January 24, 2014

Dulicate remove and collect all ralated data for that duplicate data


         $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