hi…
I have query to display data and I use while loop.
here is my code:
[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———————