zh_tcwq/inc/web/sjgroupteam.inc.php

<?php
global $_GPC, $_W;
$storeid=$_COOKIE["storeid"];
$cur_store = $this->getStoreById($storeid);
$GLOBALS['frames'] = $this->getNaveMenu2($storeid);
$sql=" select a.*,b.name as nick_name,b.img,c.store_name from".tablename('zhtc_group')." a left join ".tablename('zhtc_user')." b on a.user_id=b.id left join ".tablename('zhtc_store')." c on a.store_id=c.id where a.id=:id";
$group=pdo_fetch($sql,array(':id'=>$_GPC['id']));
$sql2=" select a.*,b.name as nick_name from".tablename('zhtc_grouporder')." a left join ".tablename('zhtc_user')." b on a.user_id=b.id where a.group_id=:id";
$order=pdo_fetchall($sql2,array(':id'=>$_GPC['id']));

include $this->template('web/sjgroupteam');