$sql = "SELECT t1.name,t2.value FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t2.id=t1.id";
其中name和value是对应关系,同一个name可以有多个value值,现在想取出的结果是二维数组,第一维是name的值,第二维是value的值,sql语句该怎么写?结果举例如下:
$a = array(
name1=>value1,
name2=>array(
0=>value2,
1=>value3
)
)
调试欢乐多
假定你使用的是mysql$sql = "SELECT t1.name,t2.value FROM table1 AS t1 LEFT JOIN table2 AS t2 ON t2.id=t1.id";$rs = mysql_query($sql);
while($row = mysql_fetch_assoc($rs)) {
$ar[$row['name']][] = $row['value'];
}