php查询数据语句，数组格式

Question

//查询的语句是这样的
$query1="select saleno,paytype from d_sale_pay_123";

$stmt = $PDO->query( $query1);
$list = array();//定义数组
while ($row = $stmt->fetch() ){
  $list[] = $row;

}
$nihao=var_dump($list);


echo "$nihao<br>";

//这个是输出的格式
array(13) { [0]=> array(4) { ["saleno"]=> string(22) "1021221119100319460212" [0]=> string(22) "1021221119100319460212" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [1]=> array(4) { ["saleno"]=> string(22) "1021221119102958623003" [0]=> string(22) "1021221119102958623003" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [2]=> array(4) { ["saleno"]=> string(22) "7021221119100651724145" [0]=> string(22) "7021221119100651724145" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [3]=> array(4) { ["saleno"]=> string(22) "7021221119120213764715" [0]=> string(22) "7021221119120213764715" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [4]=> array(4) { ["saleno"]=> string(22) "7021221119155927700252" [0]=> string(22) "7021221119155927700252" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [5]=> array(4) { ["saleno"]=> string(22) "7021221119172004884354" [0]=> string(22) "7021221119172004884354" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [6]=> array(4) { ["saleno"]=> string(22) "7021221119175602296223" [0]=> string(22) "7021221119175602296223" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [7]=> array(4) { ["saleno"]=> string(22) "7021221120090720142614" [0]=> string(22) "7021221120090720142614" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [8]=> array(4) { ["saleno"]=> string(22) "7021221120104259473435" [0]=> string(22) "7021221120104259473435" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [9]=> array(4) { ["saleno"]=> string(22) "7021221120142721677779" [0]=> string(22) "7021221120142721677779" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [10]=> array(4) { ["saleno"]=> string(22) "7021221120193519978896" [0]=> string(22) "7021221120193519978896" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [11]=> array(4) { ["saleno"]=> string(22) "7021221120204902600290" [0]=> string(22) "7021221120204902600290" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [12]=> array(4) { ["saleno"]=> string(22) "7021221120210407418001" [0]=> string(22) "7021221120210407418001" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } }

现在的数据是这样的，我想导出成Excel。需要输出的数据是下面的这种格式。这个应该怎么弄呢

 $data = array(

 array('1021221119100319460212','809080'),

array('1021221119102958623003','809080)

);

Answer 1

$query1="select saleno,paytype from d_sale_pay_123";
$stmt = $PDO->query( $query1 );
while ( $row = $stmt->fetch() ){
$data1[]=array( $row['saleno'],$row['paytype']);
 }  
print_r($data1);