问我想将值存储在变量中，然后在表中显示，但这行不通

EN

 $query_test = "SELECT itemname, categoryname, manufacturername,
                       price, shopname,itemurl, itemimage, typename  
                FROM prices p, 
                     items i, 
                     shops s, 
                     categories c, 
                     manufacturers m, 
                     types t, 
                    modules mo 
                WHERE p.shopid=s.shopid 
                  AND i.categoryid=c.categoryid 
                  AND p.itemid=i.itemid 
                  AND i.ManufacturerId=m.ManufacturerID 
                  AND i.ModuleId= mo.ModuleID 
                  AND i.TypeId=t.TypeID 
                  AND i.categoryid=1004 
                  AND s.shopid=5003";

 $result = mysqli_query($conn, $query_test);
 echo "<table border='1'>";
 echo "<tr><td>"."Name"."</td>";
 echo "<td>"."Category"."</td>";
 echo "<td>"."Manufacturer"."</td>";
 echo "<td>"."Price"."</td>";
 echo "<td>"."Shop"."</td>";
 echo "<td>"."Type"."</td>";
 while ($row = mysqli_fetch_array($result, MYSQLI_BOTH)) {
    //output a row here
    $name = $row['itemname'];
    $category = $row['categoryname'];
    $manufacturer = $row['manufacturername'];
    $price = $row['price']:
    $shop = $row['shopname'];
    $type = $row['typename'];
    echo "<tr><td>".$name."</td>";
    echo "<td>".$category."</td>";
    echo "<td>".$manufacturer."</td>";
    echo "<td>".$price."</td>";
    echo "<td>".$shop."</td>";
    echo "<td>".$type."</td></tr>";
    /*echo "<tr><td>".($row['itemname'])."</td>";
    echo "<td>".($row['categoryname'])."</td>";
    echo "<td>".($row['manufacturername'])."</td>";
    echo "<td>".($row['price'])."</td>";
     echo "<td>".($row['shopname'])."</td>";
    echo "<td>".($row['typename'])."</td></tr>";*/
 }

 echo "</table>";