多个sql语句拼接 进行循环显示
俩sql 语句 id相等
第一个sql语句
$sqlone = "select * from a inner join b on a.id =b.id";
$sqlo = mysql_query(sqlone);
循环sql语句把id当做data的键 整个数组作为值
while($v = mysql_fetch_array($sqlo)){
$data[$v['id']] = $v;
}
第二个sql语句
$sqltwo ="select * from a inner join c on a.id=c.id";
$sqlt = mysql_query(sqltwo);
循环第二个sql把id当做data1的键 整个数组作为值
while ($vo = mysql_fetch_array($sqlt)){
$data1[$vo["id"]] = $vo;
}
foreach($data as $k=>$v){
<td>$data[$k]['name']</td>//输出第一个数组中name的值
<td>$data1[$k]['name']</td>//输出第二个数组中name的值
}