如何在数据中按照金额多少排序啊
while ($row=mysql_fetch_array($info)) {
$sql="Select sum(orders_products.products_price) as 'price',sum(orders_products.products_quantity) as 'num' From orders_products,orders Where orders_products.orders_id=orders.orders_id and orders.ispay=1 and orders_products.products_id=".$row[products_id];
$infos=mysql_query($sql);
if ($infos) {
$price_row=mysql_fetch_array($infos);
$money="".$row[products_id]."=>".$price_row[price].""; 这个数组里第一个是产品的id,后面是金额
$total_all=$total_all.",".$money;
}
}
}
//自己产品销量排名,主要是这里如何排序
$order=explode(",",$total_all);
arsort($order);
$size=count($order);
for($i=0; $i<$size; $i++) {
echo($order[$i])."<br>";
}
?>
while ($row=mysql_fetch_array($info)) {
$sql="Select sum(orders_products.products_price) as 'price',sum(orders_products.products_quantity) as 'num' From orders_products,orders Where orders_products.orders_id=orders.orders_id and orders.ispay=1 and orders_products.products_id=".$row[products_id];
$infos=mysql_query($sql);
if ($infos) {
$price_row=mysql_fetch_array($infos);
$money="".$row[products_id]."=>".$price_row[price].""; 这个数组里第一个是产品的id,后面是金额
$total_all=$total_all.",".$money;
}
}
}
//自己产品销量排名,主要是这里如何排序
$order=explode(",",$total_all);
arsort($order);
$size=count($order);
for($i=0; $i<$size; $i++) {
echo($order[$i])."<br>";
}
?>
$total_all=$total_all.",".$money; //不知道你这句用意何为?有$meney数组不就行了吗?
$money // 里面是产品id和金额 如 1=》100,1是产品id是1,销售是100元
while ($row=mysql_fetch_array($info)) {
$sql="Select sum(orders_products.products_price) as 'price',sum(orders_products.products_quantity) as 'num' From orders_products,orders Where orders_products.orders_id=orders.orders_id and orders.ispay=1 and orders_products.products_id=".$row[products_id];
$infos=mysql_query($sql);
if ($infos) {
$price_row=mysql_fetch_array($infos);
//$pro_name=$SqlDB->getname($row[products_id],'products_description','products_id','products_name');
if ($price_row[price] =="") {
$prices=0;
}else{
$prices=$price_row[price];
}
$total_all[$row[products_id]]=$prices;
}
}
}
//所有产品销量排名
arsort($total_all);
//print_r($order);
$size=count($total_all);
foreach ($total_all as $key => $value) {
$pro_name=$SqlDB->getname($key,'products_description','products_id','products_name');
echo $pro_name."=".$value."<br>";
}
?>这个是正确的 ,虽然是自己解决的 ,我也会给大家结贴