hi…
I have query to display data and I use while loop.
here is my code:
echo "<table id='kanban_list'>";
echo "<tr>
<th><label>Display Details:</label><input onclick='showDetails(this);' id='chkDetail' type='checkbox' checked='checked' value='wip'/></th>
<th> PCODE </th>
<th> LOT CODE </th>
<th> CHEMICAL WEIGHING </th>
<th> COMPOUNDING </th>
<th> EXTRUSION </th>
<th> FORMING </th>
<th> DEFLASHING </th>
<th> KANBAN </th>
<th> VIRTUAL </th>
<th> TOTAL </th>
<!--<th> MIN LOT </th>-->
</tr>";
$sql = "SELECT DISTINCT kd.PCODE, kc.count_wip_chemical_weighing, kc.count_wip_compounding, kc.count_wip_extrusion,
kc.count_wip_forming, kc.count_wip_deflashing, kc.kanban, kc.virtual, kc.total FROM kanban_checker kc JOIN kanban_data kd ON kc.PCODE = kd.PCODE
ORDER BY kc.PCODE";
$result = mysql_query($sql, $con);
while($row = mysql_fetch_assoc($result)){
echo "<tr>
<td>Total Lot ID (Lot)</td>
<td> $row[PCODE]</td>
<td> </td>
<td> $row[count_wip_chemical_weighing]</td>
<td> $row[count_wip_compounding]</td>
<td> $row[count_wip_extrusion]</td>
<td> $row[count_wip_forming]</td>
<td> $row[count_wip_deflashing]</td>
<td> $row[kanban]</td>
<td> $row[virtual]</td>
<td> $row[total]</td>
<!-- <td> $row[min_lot]</td> -->
</tr>";
}
$sql = "SELECT DISTINCT kd.PCODE, kdc.count_doz_chemical_weighing, kdc.count_doz_compounding, kdc.count_doz_extrusion,
kdc.count_doz_forming, kdc.count_doz_deflashing, kdc.kanban_doz, kdc.virtual_doz, kdc.total_doz FROM kanban_checker_doz kdc JOIN kanban_data kd ON kdc.PCODE = kd.PCODE
WHERE kd.PCODE = '$row[PCODE]'
ORDER BY kdc.PCODE";
$result_qty = mysql_query($sql, $con);
while ($row_doz = mysql_fetch_assoc($result_qty)){
echo "<tr>
<td>Total Qty (Doz)</td>
<!--<td> </td> -->
<td> $row_doz[PCODE]</td>
<td> </td>
<td> $row_doz[count_doz_chemical_weighing]</td>
<td> $row_doz[count_doz_compounding]</td>
<td> $row_doz[count_doz_extrusion]</td>
<td> $row_doz[count_doz_forming]</td>
<td> $row_doz[count_doz_deflashing]</td>
<td> $row_doz[kanban_doz]</td>
<td> $row_doz[virtual_doz]</td>
<td> $row_doz[total_doz]</td>
<!-- <td> $row[min_lot]</td> -->
</tr>";
}
echo "</table>";
sample data:
Display Details—Compound—Chemical Weighing-----etc…
---------------------P28------------1.00----------------------------
---------------------P28------------250.00------------------------
---------------------P30------------2.00--------------------------
---------------------P30------------520.00---------------------
---------------------P32------------1.00----------------------------
I need to add alternate background color per compound.
for example:
P28 green
P30 yellow
P32 green
P33 yellow
and so on.
Any help is highly appreciated.
Thank you
---------------------P32------------520.00-----------------------
---------------------P33------------4.00----------------------------
---------------------P33------------1000.00---------------------