在Php中联接两个表 [英] Join two tables in Php

问题描述

我有两个桌子

表1类别

Id    name      img   
1   appliances   
2   books

表2产品

ID  name des  price  cataegory sub  img
1  TV    lcd  125     1        tv

我正在尝试将表2中类别中的两个表连接起来，直到从表1中获取名称

I am trying to join the two tables that in category in table 2 till get the name from table 1

这是我的代码

    $sql = "SELECT p.id, 
                   p.name,
                   p.description, 
                   p.price,
                   c.name,
                   p.sub
            FROM products p
            JOIN category c on products p = c.id
            ORDER by p.id
            ";

    if($query =  mysql_query($sql) or die())
    {
        while($result = mysql_fetch_assoc($query))
        {   echo "<tr id='id'>";
            //echo "<td>".$result['img']."</td>";
            echo "<td>".$result['name']."</td>";
            echo "<td>".$result['description']."</td>";
            echo "<td>".$result['price']."</td>";
            echo "<td>".$result['category']."</td>";
            echo "<td>".$result['sub']."</td>";
            echo "</tr>";
        }
    }       ";

推荐答案

将类别名称添加到选择查询返回的列中:

Add category name to the columns returned by select query:

$sql = "SELECT p.id, 
                   p.name,
                   p.description, 
                   p.price,
                   c.name,
                   p.sub,
                   c.name AS category_name       -- Category name
            FROM products p
            JOIN category c on p.category = c.id
            ORDER by p.id
            ";

这篇关于在Php中联接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！