duanjuan3931 2015-05-21 13:54
浏览 24

在PHP中显示多个MYSQL查询

I have 3 queries. I want all 3 of them to run at one time and display the result. Here is my code:

$query = mysqli_query($connect ,"SELECT w2.Avis as Avis,w2.Cde_Sap,w2.Don_Ordre,w2.Num_cde_cl,w2.PN_in ,w2.SN_in,w2.DATE2,w2.Statut_Cde,client.Zone
 FROM w2
 INNER JOIN client
 ON w2.Don_Ordre = client.Client 
 WHERE client.Zone='AFZ' 

 UNION ALL

 SELECT w3.Avis,w3.Cde_Sap,w3.Don_Ordre,w3.Num_cde_cl,w3.PN_in ,w3.SN_in,w3.DATE2,w3.Statut_Cde,client.Zone
FROM w3
INNER JOIN client
ON w3.Don_Ordre = client.Client 
WHERE client.Zone='AFZ'

ORDER BY Avis DESC;") ;

Query 2

$query2= "SELECT SUBSTRING_INDEX(w2.Statut_Cde, ' ', -1) FROM w2;";

Query 3

$query3 = "SELECT SUBSTRING_INDEX(w3.Statut_Cde, ' ', -1) FROM w3;" ;

Table display

<?php

while($w2= mysqli_fetch_assoc($query)){
    echo"<tr>";

    echo"<td>".$w2['Avis']."</td>";
    echo"<td>".$w2['Cde_Sap']."</td>";
    echo"<td>".$w2['Don_Ordre']."</td>";
    echo"<td>".$w2['Num_cde_cl']."</td>";
    echo"<td>".$w2['PN_in']."</td>";
    echo"<td>".$w2['SN_in']."</td>";
    echo"<td>".$w2['DATE2']."</td>";
    echo"<td>".$w2['Statut_Cde']."</td>";
    echo"<td>".$w2['Zone']."</td>";
//  echo"<td>".$w2['Comment']."</td>";

}//end while 
while($w3= mysqli_fetch_assoc($query)){
    echo"<tr>";

    echo"<td>".$w3['Avis']."</td>";
    echo"<td>".$w3['Cde_Sap']."</td>";
    echo"<td>".$w3['Don_Ordre']."</td>";
    echo"<td>".$w3['Num_cde_cl']."</td>";
    echo"<td>".$w3['PN_in']."</td>";
    echo"<td>".$w3['SN_in']."</td>";
    echo"<td>".$w3['DATE2']."</td>";
    echo"<td>".$w3['Statut_Cde']."</td>";
    echo"<td>".$w3['Zone']."</td>";
//  echo"<td>".$w3['Comment']."</td>";

}//end while 

?>

Help with the execution of 3 queries.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
    • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行