21,886
社区成员
发帖
与我相关
我的任务
分享
select * from _goods order by price+0 asc
$sql="select * from _goods";
$result=mysql_query($sql);
while($row=mysql_fetch_row($result)){ //把每行的结果放入数组,这里共有4个1维数组
$i++; //出循环后,$i=记录集的总行数
$id[$i]=$row[0];
$name[$i]=$row[1];
$remarks[$i]=$row[2];
$price[$i]=$row[3];
}
for($j=1;$j<$i;$j++){ //按$price从小到大输出
for($k=$j+1;$k<$i+1;$k++){
if($price{[$j]>$price[$k]){
$a=$id{[$j]; $id{[$j]=$id[$k];$id[$k]=$a;
$a=$name{[$j]; $name{[$j]=$name[$k];$name[$k]=$a;
$a=$remarks{[$j]; $remarks{[$j]=$remarks[$k];$remarks[$k]=$a;
$a=$price{[$j]; $price{[$j]=$price[$k];$price[$k]=$a;
}
}
echo $id[$j].'.'.$name[$j].'.'.$remarks[$j].'.'.$price[$j].'<br>';
}
$sql="select * from _itemtypeinfo,_suppliersinfo,_purchasegoodsinfo,_goodspriceinfo where
_suppliersinfo.tid=_itemtypeinfo.id and _purchasegoodsinfo.sid=_suppliersinfo.id and
_purchasegoodsinfo.tid=_itemtypeinfo.id and _goodspriceinfo.gid=_purchasegoodsinfo.id
and _itemtypeinfo.state!=1 and _goodspriceinfo.state!=1 and _purchasegoodsinfo.state!=1 and _suppliersinfo.state!=1 and _itemtypeinfo.typename like '%".$content."%' or
_suppliersinfo.supplyname like '%".$content."%' or _purchasegoodsinfo.goodsname like '%".$content."%' ";
}
$result=mysql_query($sql) or die("SQL Error: <br>".$sql."<br>".mysql_error());
$count=mysql_num_rows($result);
if($count!=0){
/*function ORD_ASC($a,$b){
if($a==$b){
return 0;
}
return ($a<$b)?-1:1;
}
*/
while($row=mysql_fetch_array($result)){
$data[]=$row['price'];
//$data1[]=$row['id'];
//$array=array("id"=>$data1,"price"=>$data);
//usort($data,"ORD_ASC");
sort($data,SORT_NUMERIC);
print_r($data);
//echo sizeof($array['price']);
//echo $data[0];
//print_r($data);
/* foreach($data as $price)*/
/*$count=count($data);*/
for($i=0;$i<count($data[0]);$i++){}
?>
<tr>
<td><input type="checkbox" name="select[]" value="" /></td>
<td><?=$row['typename']?></td>
<td><?=$row['goodsname']?></td>
<td><?=$row['supplyname']?></td>
<td><? echo $data[$i]; ?></td>
<td><?=$row['tel1']."/".$row['tel2']."/".$row['tel3']."/".$row['tel4'] ?></td>
</tr>
<?
}
/* }
}
}
}*/
}
else{
?>
<tr>
<td colspan="6"><font color="blue">很抱歉,沒有相關的資料.</font></td>
</tr>
<?
}
?>
$data[]=$row['price'];
sort($data,SORT_NUMERIC);
print_r($data);
print_r(array_reverse($data));