Question

php mysql 查询只取第一条！

为什么这个只取第一条值 而不是多条呢？测试过加foreach 但是好像我加的也不对，只取第一条$query = $mysql_query("select * from table1 where id in (select id from table2) limit 0,7 ");
while($rs = $mysql_fetch_array($query)){ print:("$rs[id]");}

Answer 1

这样不行，你要先遍历table2，取出id到数组，然后循环这个数组，对每个id值再从table1中查找

Answer 2

$query = mysql_query("select * from table1 where id in (select id from table2) limit 0,7 ");
while($rs = mysql_fetch_array($query)){ print:("$rs[id]");} 或者这么写 $query = $mysql_query("select * from table1 as a left join table2 as b on b.id=a.id limit 0,7 ");
while($rs = $mysql_fetch_array($query)){ print:("$rs[id]");}

Answer 3

$query = $mysql_query("select * from table1 where id in (select id from table2) limit 0,7 ");//mysql_query是一个php函数,函数怎么能加$了
while($rs = $mysql_fetch_array($query)){ print:("$rs[id]");}

Answer 4

看着很别扭啊试试这个$query = mysql_query("select * from table1 where id in(select id from table2) limit 0,7");while($rs = mysql_fetch_array($query)){echo $rs["id"];}

Answer 5

select id from table2 你不遍历他的值肯定只能取一条了 而且规范的sql语句也没你这么写的吧