$sql = "SELECT id,content,pic1,pic2,pic3,pic4,display FROM ".MX_TABLEPRE."sexgame WHERE orientation='$orientation' and style='$style'";
$res = $db->query($sql);
$arr = array();
while ($row = $db->fetchRow($res))
{
$arr[$row['id']]['id'] = $row['id'];
$arr[$row['id']]['content'] = $row['content'];
$arr[$row['id']]['pic1'] = $row['pic1'];
$arr[$row['id']]['pic2'] = $row['pic2'];
$arr[$row['id']]['pic3'] = $row['pic3'];
$arr[$row['id']]['pic4'] = $row['pic4'];
$arr[$row['id']]['display'] = $row['display'];
$sql_tool = "SELECT gt.id,sexgameid,toolname FROM ".MX_TABLEPRE."gametoolrule as gt,".MX_TABLEPRE."gametool as gm WHERE gt.toolid=gm.id and gt.sexgameid='".$row['id']."'";
$tool_res = $db->getAll($sql_tool);
foreach($tool_res as $key=>$value)
{
$arrs[] = $value;
}
$arr[$row['id']]['toolid'] = $arrs;
}
各位,帮忙看看这个位置要怎么修改,第二条数据库的道具有一条是第一条的,怎么才能把它去掉,帮忙看下,感激不尽
以上, 试一下吧,