php – 如何在单个while循环中从多个查询中检索值？

在给定的代码中,我需要打印从查询$q1获得的train-name,但是在我提供的echo语句中,这不起作用.如何在给定代码中打印trainname？

$q1="SELECT st_name FROM tbl_station where st_code='$f'";

$r1=MysqL_query($q1);

while($row = MysqL_fetch_array($r1)) 

{

$trainname=$r1['st_name'];

}   

$query="SELECT A.train_no AS AA, A.station_id AS AB, A.arrival AS AC, A.dept AS AD, 

B.station_id AS AE, B.arrival AS AF, B.dept AS AG FROM TIME AS A,TIME AS B WHERE A.train_no 

= B.train_no AND A.station_id ='$f' AND B.station_id ='$t'";

$rs=MysqL_query($query);

while($row = MysqL_fetch_array($rs)) 

{

echo "<tr><td>".$row['AA']."</td> <td>".$trainname."</td> <td>" .$row['AC'] ."</td> 

<td>".$row['AD'] . "</td><td>".$row['AE'] . "</td><td>".$row['AF'] . "</td><td>" 

.$row['AG']. "</td><td>"."<a href='Reservation.PHP'>Click Me</a><tr><td>";

}

解决方法:

结果行分配给$row变量,而不是$r1变量(这是查询资源)：

while($row = MysqL_fetch_array($r1)) 
{  
  $trainname=$row['st_name'];   
} 

（编辑：北几岛）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!