请教一个循环嵌套,大家帮忙看看吧
storenametable
+----+-----------+
| id | storename |
+----+-----------+
| 2 | 天字二号仓|
+----+-----------+
| 7 | 天字七号仓|
+----+-----------+
| 8 | 天字八号仓|
+----+-----------+
storetable
+----+-----------+---------+--------+
| id |storenumber| product | number |
+----+-----------+---------+--------+
| 1 | 2 | 大米 | 10 |
+----+-----------+---------+--------+
| 2 | 7 | 玉米 | 10 |
+----+-----------+---------+--------+
| 3 | 7 | 面粉 | 15 |
+----+-----------+---------+--------+
| 4 | 8 | 花生 | 10 |
+----+-----------+---------+--------+
| 5 | 8 | 大豆 | 15 |
+----+-----------+---------+--------+
$sql = "Select * From `storenametable` where id>3 order by id desc limit 0,2 ";
$dsql->Execute('st',$sql);
while($row = $dsql->GetArray('st'))
{
$sqlarc = "Select * From `storetable` where storenumber={$row['id']} order by id desc limit 0,2 ";
$dsql->Execute('arc',$sqlarc);
while($rowarc = $dsql->GetArray('arc'))
{
$data.='<a>'.$rowarc['product'].'</a>';
}
echo $data;
}
郁闷,大家帮忙看看
为什么此处echo结果是:
玉米 面粉 玉米 面粉 花生 大豆
而不是:
玉米 面粉 花生 大豆
就是说重复了一个 玉米 面粉