php - 如何显示 3 个 mysql 表的值

Question

我必须显示三个 mysql 表(package、supplier、requests)中的值。

表:包

表:供应商

表:请求

我想像这样显示最终结果

最终结果

这是我尝试过的查询。

$query= "SELECT package.p_name, supplier.cat, supplier.cat_action,requests.cat_action, package.cost_for_cat, package.leads_per_month, package.package_price 
 FROM package
 LEFT JOIN supplier
 ON package.category = supplier.cat
 AND supplier.email='".$_SESSION["mail"]."'
 LEFT JOIN requests
 ON package.package_id = requests.package_id
 GROUP BY requests.package_id
 ORDER BY package.package_id DESC
"; 

            $result= mysql_query($query);
            $sum = 0;
        while($row = mysql_fetch_assoc($result))
            {
            echo '<tr >';
                    echo '<td>'.$row['p_name'].'</td>';
                    echo '<td>'.$row['cat'].'</td>';
                     echo '<td>'.'<I>'.$row['cat_action'].'</I>'.'</td>';
                    echo '<td>'.'£ '.$row['cost_for_cat'].'</td>';
                    echo '<td>'.$row['leads_per_month'].'</td>';
                    echo '<td style="text-align:right;">'.'<label id="pprice">'.'£ '.$row['package_price'].'</label>'.'</td>';

                echo '</tr>';

                echo '<tr>';
                    echo '<td>&nbsp;</td>';
                    echo '<td>&nbsp;</td>';
                     echo '<td>&nbsp;</td>';
                    echo '<td>&nbsp;</td>';
                    echo '<td>TOTAL</td>';
                    echo '<td style="text-align:right;">'.'£ '.'<label id="pprice">'.$sum += $row['package_price'].'</label>'.'</td>';

                echo '</tr>';       
            }

但是显示结果是这样的

Answer 1

试试这个，它会起作用:

SQL 查询:

SELECT t1.`p_name`,t1.`category`,t2.`cat_action`,t1.`cost_for_cat`,t1.`leads_per_month`,t1.`package_price` FROM package t1
JOIN requests t2 ON t2.`package_id`=t1.`package_id`
JOIN Supplier t3 ON t3.`supplier_id`=t2.`supplier_id`