Issue in duplicate display data

[newphpcoder]

Hi...

 

I encountered problem in my query and while loop my data was duplicates when I join 2 tables, because the one field that I need to display is from another table.

 

here is my code:

 

<div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT Items FROM bom_items ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
echo "<tr>
        <td style='border: none;font-weight: bold;'> $row[items]</td>
        </tr>";       
//$sql = "SELECT SubItems, ItemCode, UoM, Class, Description FROM bom_subitems WHERE Items = '$row[items]' ORDER BY Items"or die(mysql_error());
//$sql = "SELECT DISTINCT bs.SubItems, bs.ItemCode, bs.UoM, bs.Class, bs.Description,w.BINLocation FROM bom_subitems bs LEFT JOIN wms w ON bs.Items = w.Items WHERE bs.Items = '$row[items]' AND w.Items = '$row[items]' ORDER BY bs.Items, w.Items"or die(mysql_error());
$sql = "SELECT DISTINCT bs.SubItems, bs.ItemCode, bs.UoM, bs.Class, bs.Description,w.BINLocation FROM bom_subitems bs, wms w WHERE bs.Items = '$row[items]' AND w.Items = '$row[items]' ORDER BY bs.Items, w.Items"or die(mysql_error());
$res_sub = mysql_query($sql, $con);

while($row_sub = mysql_fetch_assoc($res_sub)){
    echo "<tr>
        <td style='border: none;'> </td>
        <td style='border: none;'> $row_sub[subItems]</td>
        <td style='border: none;'> $row_sub[itemCode]</td>
        <td> </td>
        <td style='border: none;' size='3'> $row_sub[uoM]</td>
        <td style='border: none;'> $row_sub[Class]</td>
        <td style='border: none;'> $row_sub[Description]</td>
        <td style='border: none;'> $row_sub[bINLocation]</td>     
        </tr>";

}
}    
?>

 

I will attach my sample page.

 

Thank you

[darkfreaks]

you need to most likely use count distinct.

 

SELECT COUNT (DISTINCT , bs.SubItems, bs.ItemCode, bs.UoM, bs.Class, bs.Description,w.BINLocation) FROM bom_subitems bs, wms w WHERE bs.Items = '$row[items]' AND w.Items = '$row[items]' ORDER BY bs.Items, w.Items

 

 

[newphpcoder]

I use your suggested code and No data display...

 

Thanks