21,886
社区成员
发帖
与我相关
我的任务
分享
SELECT B_table.id,B_table.name,B_table.age FROM A_table,B_table
WHERE A_table.id=B_table.id or A_table.name=B_table.name or A_table.age=B_table.age
SEECT B_table.id,B_table.name,B_table.age FROM A_table,B_table
WHERE A_table.id=B_table.id or A_table.name=B_table.name or A_table.age=B_table.age
$sql1 = "SELECT * FROM t1 WHERE parent = '0' ;";
$re1 = mysql_query($sql);
while($rs1 = mysql_fetch_array($re1)) {
echo 'Parent:' . $rs1['name'] . '</br>\n'; //list parent
$sql2 = "SELECT * FROM t1 WHERE parent = '" . $rs1['id'] . "' ;";
$re2 = mysql_query($sql2);
while($rs2 = mysql_fetch_array($re2)) {
echo ' Child:' . $rs1['name'] . '</br>\n'; //list children
}
}
while ( $row = mysql_fetch_array( $rs ) ){
foreach( $row as $key => $value ){
echo $value ." " ;
}
echo "<br />" ;
}