Issue in duplicate display data

[newphpbees]

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;'>&nbsp;$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;'>&nbsp;</td>
<td style='border: none;'>&nbsp;$row_sub[SubItems]</td>
<td style='border: none;'>&nbsp;$row_sub[ItemCode]</td>
<td>&nbsp;</td>
<td style='border: none;' size='3'>&nbsp;$row_sub[UoM]</td>
<td style='border: none;'>&nbsp;$row_sub[Class]</td>
<td style='border: none;'>&nbsp;$row_sub[Description]</td>
<td style='border: none;'>&nbsp;$row_sub[BINLocation]</td>
</tr>";

}
}
?>


I will attach my sample page.

Thank you

[jassmee]

If your data is display duplicate data then you may used group by... it is used to avoid duplicate data...