這個問題在這里已經有了答案： 如何訪問具有相同名稱不同表的多個 mysql 行 1 個回答 來自具有相同列名的兩個表的資料 4 個回答 32 分鐘前關閉。
我的 php 代碼
$result = mysqli_query($db,"SELECT * FROM pslf_orders, pslf_order_detail, pslf_order_history, pslf_order_state_lang WHERE
pslf_orders.id_order = pslf_order_detail.id_order AND
pslf_order_detail.id_order = pslf_order_history.id_order AND
pslf_order_history.id_order_state = pslf_order_state_lang.id_order_state AND
pslf_orders.id_lang = pslf_order_state_lang.id_lang AND
pslf_orders.id_customer = $Id AND pslf_order_state_lang.id_lang = 1 ");
while($row = mysqli_fetch_array($result)){
//here i want to show $row['id_lang'];
}
但問題是在 2 個不同的表中有相同的名稱行 (id_lang)
1- pslf_orders.id_lang
2- pslf_order_state_lang.id_lang
我如何顯示兩個表中的資料
我試過的
$row['pslf_orders.id_lang'];
$row['pslf_order_state_lang.id_lang'];
但這不起作用。
uj5u.com熱心網友回復：
使用別名
SELECT
pslf_orders.id_lang AS order_id_lang,
pslf_order_state_lang.id_lang AS state_id_lang,
*
FROM pslf_orders....
WHERE ...
uj5u.com熱心網友回復：
使用@PersianMan 建議的別名，如下所示：
$result = mysqli_query($db,"SELECT pslf_orders.id_lang as pslf_orders__id_lang, pslf_order_state_lang.id_lang as pslf_order_state_lang__id_lang, * FROM pslf_orders, pslf_order_detail, pslf_order_history, pslf_order_state_lang WHERE
pslf_orders.id_order = pslf_order_detail.id_order AND
pslf_order_detail.id_order = pslf_order_history.id_order AND
pslf_order_history.id_order_state = pslf_order_state_lang.id_order_state AND
pslf_orders.id_lang = pslf_order_state_lang.id_lang AND
pslf_orders.id_customer = $Id AND pslf_order_state_lang.id_lang = 1 ");
while($row = mysqli_fetch_array($result)){
$row['pslf_orders__id_lang'];
$row['pslf_order_state_lang__id_lang'];
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/349041.html