当数据表里有一条记录时显示正常,有2条以上的记录时,显示出来的第一条会和第二条一样,第二条还是第二条,其他都正常,就是第一条显示成第二条的内容,我不懂php,求大神帮忙修改下,下面是部分代码,不知道这些代码能查出问题吗?
是sql查询不对,还是分解数组不对,多谢! <div id="imgGroup"> {loop $wantorders $v} <img src="{$v['user']['avatar']}" alt="{$v['user']['nickname']}, · ¥ {$v['income']}"> {/loop} </div> public function get_pay_orders($openid = '')
{
global $_W, $_GPC;
if ($openid != '') {
$orders = pdo_fetchall('SELECT * FROM ' . tablename('wdl_pyqqt_pay') . ' WHERE uniacid = :uniacid AND origin = :origin ORDER BY add_time DESC', array(
':uniacid' => $_W['uniacid'],
'origin' => $openid
));
} else {
$orders = pdo_fetchall('SELECT DISTINCT(origin) FROM ' . tablename('wdl_pyqqt_pay') . ' WHERE uniacid = :uniacid ORDER BY add_time DESC', array(
':uniacid' => $_W['uniacid']
));
}
return $orders;
}
public function doMobileSleep()
{
global $_W, $_GPC;
$config = $this->get_config($_GPC['openid']);
$myorder = pdo_get('wdl_pyqqt_pay', array(
'uniacid' => $_W['uniacid'],
'origin' => $_GPC['openid'],
'want' => $_W['openid']
));
$wantorders = $this->get_pay_orders($_GPC['openid']);
foreach ($wantorders as $k => &$v) {
$v['income'] = $this->get_income($v['want']);
$v['user'] = $this->get_user_info($v['want']);
}
$income = $this->get_income($_GPC['openid']);
$user = $this->get_user_info($_GPC['openid']);
$user['income'] = $income;
$my = $this->get_user_info($_W['openid']);
include $this->template('sleep');
}
是sql查询不对,还是分解数组不对,多谢! <div id="imgGroup"> {loop $wantorders $v} <img src="{$v['user']['avatar']}" alt="{$v['user']['nickname']}, · ¥ {$v['income']}"> {/loop} </div> public function get_pay_orders($openid = '')
{
global $_W, $_GPC;
if ($openid != '') {
$orders = pdo_fetchall('SELECT * FROM ' . tablename('wdl_pyqqt_pay') . ' WHERE uniacid = :uniacid AND origin = :origin ORDER BY add_time DESC', array(
':uniacid' => $_W['uniacid'],
'origin' => $openid
));
} else {
$orders = pdo_fetchall('SELECT DISTINCT(origin) FROM ' . tablename('wdl_pyqqt_pay') . ' WHERE uniacid = :uniacid ORDER BY add_time DESC', array(
':uniacid' => $_W['uniacid']
));
}
return $orders;
}
public function doMobileSleep()
{
global $_W, $_GPC;
$config = $this->get_config($_GPC['openid']);
$myorder = pdo_get('wdl_pyqqt_pay', array(
'uniacid' => $_W['uniacid'],
'origin' => $_GPC['openid'],
'want' => $_W['openid']
));
$wantorders = $this->get_pay_orders($_GPC['openid']);
foreach ($wantorders as $k => &$v) {
$v['income'] = $this->get_income($v['want']);
$v['user'] = $this->get_user_info($v['want']);
}
$income = $this->get_income($_GPC['openid']);
$user = $this->get_user_info($_GPC['openid']);
$user['income'] = $income;
$my = $this->get_user_info($_W['openid']);
include $this->template('sleep');
}
你贴的代码很乱,最起码应该说明在哪段代码能看出来第一条和第二条重复