我有一个查询
$arr_status = array('1' => '申请中', '2'=>'处理中', '3' => '已发货', '4' => '已退款');
$lotterylist = array();
$sqltext = "SELECT* FROM {$tablepre}exchange WHERE uid = '$discuz_uid' ORDER BY exchangetime DESC LIMIT $start_limit, $tpp";
$query = $db->query($sqltext);
while($lottery = $db->fetch_array($query)) {
$lotterylist[$lottery['giftid']] = $lottery;
$lotterylist[$lottery['giftid']]['status_name'] = $arr_status[$lottery['status']];
$lotterylist[$lottery['giftid']]['exchangetime'] = date('m-d H:i',$lottery['exchangetime']);
}
完成之后,我用count($lotterylist)得到的结果是4
但是我print出$sqltext,拿到数据库去执行,得到的记录结果有9条。这就很奇怪了。到底是怎么回事呢?
$arr_status = array('1' => '申请中', '2'=>'处理中', '3' => '已发货', '4' => '已退款');
$lotterylist = array();
$sqltext = "SELECT* FROM {$tablepre}exchange WHERE uid = '$discuz_uid' ORDER BY exchangetime DESC LIMIT $start_limit, $tpp";
$query = $db->query($sqltext);
while($lottery = $db->fetch_array($query)) {
$lotterylist[$lottery['giftid']] = $lottery;
$lotterylist[$lottery['giftid']]['status_name'] = $arr_status[$lottery['status']];
$lotterylist[$lottery['giftid']]['exchangetime'] = date('m-d H:i',$lottery['exchangetime']);
}
完成之后,我用count($lotterylist)得到的结果是4
但是我print出$sqltext,拿到数据库去执行,得到的记录结果有9条。这就很奇怪了。到底是怎么回事呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货