I have query which I display data in while loop but my problem is the first repeated after the second row display.
here is my code and also I attach the image display output.
<?php
error_reporting(0);
$con = mysql_connect('localhost', 'root','');
if (!$con) {
echo 'failed';
die();
}
mysql_select_db("mes", $con);
?>
<style type="text/css">
table {
margin: 9px;
}
th {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
background: #694;
color: #FFF;
padding: 2px 6px;
border-collapse: separate;
border: 1px solid #000;
}
td {
font-family: Arial, Helvetica, sans-serif;
font-size: .7em;
border: 1px solid #DDD;
text-align: right;
}
</style>
<script type="text/javascript">
function showDetails(pcode) {
var clickElement = pcode.value;
var click_id = pcode.id;
// var value_ = document.getElementById(click_id).checked
// = document.getElementById(clickElement).checked;
//var Table = (document.getElementsByName('list')[0].value);
var Table = document.getElementById('kanban_list');
var rows = Table.rows;
var strSelect = document.getElementById(click_id).value;
//alert(strSelect)
for (var i = 0; i < rows.length; i++) {
var row = rows[i];
//row.style.display = (row.id.substr(0,3) == strSelect) ? 'none' : '';
//row.style.display = (row.id.substr(0,3) == strSelect) ?
// row.style.display = 'none';
// row.style.display = '';
if (row.id.substr(0,3) == strSelect) {
row.style.display = ((document.getElementById(click_id).checked) == false) ? 'none' : ''
}
//(document.getElementById(click_id).checked == false) ? 'none' : '' : '';
}
}
</script>
<?php
$sql = "SELECT kc.PCODE, kd.LOT_CODE, kd.wip_chemicalweighing, kd.wip_compounding, kd.wip_extrusion, kd.wip_forming,
kd.wip_deflashing, 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, p.max_lot, p.min_lot
FROM kanban_data kd JOIN kanban_checker kc ON kd.PCODE = kc.PCODE
JOIN plan p ON kc.PCODE = p.PCODE ORDER BY kc.PCODE";
$result = mysql_query($sql, $con);
?><label>Display Details:</label><input onclick='showDetails(this);' id='chkDetail' type='checkbox' checked='checked' value='wip'/>
<?php
echo "<table id='kanban_list'>";
echo "<tr>
<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> MAX LOT </th>
<th> MIN LOT </th>
</tr>";
while($row = mysql_fetch_assoc($result)){
echo "<tr>
<td>$row[PCODE]</td>
<td> </td>
<!-- <td>$row[LOT_CODE]</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[max_lot]</td>
<td>$row[min_lot]</td>
</tr>";
echo "<tr id='wip'>
<td></td>
<td> $row[LOT_CODE]</td>
<td> $row[wip_chemicalweighing]</td>
<td> $row[wip_compounding]</td>
<td> $row[wip_extrusion]</td>
<td> $row[wip_forming]</td>
<td> $row[wip_deflashing]</td>
</tr>";
}
echo "</table>";
?>
I attach the output:
I want to display the first row once…I think the problem is in my logic condition.but I don’t know how can I change my condition. to display the first row once and after the row display the second row which has lot codes.
Thank you