Good day!
I encountered an error at line 26, error: expected ‘;’
I can’t see what is the cuase of that error.
I attached my codes.
Thank you
it’s telling you that you have left out a ; at or near line 26.
it should be easy to find where.
it has ;
I can see your “pending” attachment.
why not just post your code.
you probably forgot the ; before line 26. The parser failed when it couldn’t go on at line 26.
As Kalon mention just post your code using [ php ] tags, and also it’s code not codes 
<html>
<head>
<script language="javascript">
function handleEnter(e, nextfield)
{
var characterCode = (e && e.which)? e.which: e.keyCode;
if(characterCode == 13)
{
document.getElementById(nextfield).focus();
return false;
}
else
{
return true;
}
}
// -------------- BEGIN startCalc, Calc, and stopCalc code here -------------
function startCalc(){
interval = setInterval("calc()",1);
}
function calc(){
var qty = new Array(2);
var qty[0] = parseInt(document.clttype.inqty);
var qty[1] = parseInt(document.clttype.outqty);
//var qty0 = parseInt(document.clttype.inqty[0]);
// var qty1 = parseInt(document.clttype.outqty[0]);
myqtyval = qty[0]-qty[1];
//myqtyval = qty0-qty1;
//somedat = "hello" + myqtyval;
//document.write(somedat);
document.clttype.varqty[0].value = myqtyval;
//document.getElementById("varqty")= myqtyval;
//document.getElementById('mytest').value = myqtyval;
}
function stopCalc(){
clearInterval(interval);
}
// -------------- END startCalc, Calc, and stopCalc code here -----------------
</script>
</head>
<body onLoad="document.clttype.clt_no.focus();">
<?php
error_reporting(0); //added for testing
include("config.php");
$rexist = 0;
if($_POST["clt_no"])
{
$clt_date = $_POST["clt_date"];
$query = "INSERT INTO clt_transact (clt_no, ac2l, b3, cloth_type, roll_no, transact_date, clt_date, pack_setting) VALUES ('" . $_POST["clt_no"] . "', '" . $_POST["ac2l"] . "', '" . $_POST["b3"] . "', '" . $_POST["cloth_type"] . "', '" . $_POST["roll_no"] . "', now(), '" . $clt_date . "', '" . $_POST["pack"] . "')";
$result = mysql_query($query);
$clt_transact_id = mysql_insert_id();
$opname = $_POST["opname"];
$timein = $_POST["timein"];
$timeout = $_POST["timeout"];
$inqty = $_POST["inqty"];
$iun = $_POST["iun"];
$outqty = $_POST["outqty"];
$oun = $_POST["oun"];
$idno = $_POST["idno"];
$mcno = $_POST["mcno"];
$varqty = $_POST["varqty"];
$varsublot = $_POST["varsublot"];
$dateshift = $_POST["dateshift"];
$shift = $_POST["shift"];
$totalarr = count($opname) - 1;
for($ctr=0; $ctr < $totalarr; $ctr++)
{
$inqty[$ctr] = (float) $inqty[$ctr];
$varqty[$ctr] = (float) $varqty[$ctr];
$outqty[$ctr] = (float) $outqty[$ctr];
$query = "INSERT INTO clt_traceability (operation_name, time_in, time_out, input_qty, input_unit, output_qty, output_unit, id_no, mc_no, variance_qty, variance_sublot, date, shift, clt_transact_id) VALUES ('" . $opname[$ctr] . "', '" . $timein[$ctr] . "', '" . $timeout[$ctr] . "', '" . $inqty[$ctr] . "' , '" . $iun[$ctr] . "' ,'" . $outqty[$ctr] . "', '" . $oun[$ctr] . "' , '" . $idno[$ctr] . "', '" . $mcno[$ctr] . "', '" . $varqty[$ctr] . "', '" . $varsublot[$ctr] . "', '" . $dateshift[$ctr] . "', '" . $shift[$ctr] . "', '" . $clt_transact_id . "')";
$result = mysql_query($query);
}
}
$rexist = 0;
?>
<!--<p><a href="clt_definition.php">Clt Types</a> <a href="clt_query.php">Query</a></p>-->
<?php
include("menu.php");
?>
<form action="clt_main.php" method="post" name="clttype">
<?php
$rexist = 1;
echo "Clt No:<input type='text' name='clt_no' onkeypress='return handleEnter(event,\\"clt_date\\");' />";
echo "<input type='radio' name='pack' id='mother' value='Mother Lot' /> Mother Lot<br />";
echo "CLT Date:<input type='text' name='clt_date' onkeypress='return handleEnter(event,\\"ac2l\\");' />";
echo "<input type='radio' name='pack' id='child' value='Child Lot' /> Child Lot";
echo "<table>";
echo "<tr><th class='myclass'>PARTS</th><th class='myclass'>LOT/BATCH #</th></tr>";
echo "<tr><td>AC2L</td><td><input type='text' name='ac2l' id='ac2l' onkeypress='return handleEnter(event,\\"b3\\");' /></td></tr>";
echo "<tr><td>B3</td><td><input type='text' name='b3' id='b3' onkeypress='return handleEnter(event,\\"cloth_type\\");' /></td></tr>";
echo "<tr><td>Cloth Type</td><td><input type='text' name='cloth_type' id='cloth_type' onkeypress='return handleEnter(event,\\"roll_no\\");' /></td></tr>";
echo "<tr><td>Roll No</td><td><input type='text' name='roll_no' id='roll_no' onkeypress='return handleEnter(event,\\"timein0\\");' /></td></tr>";
echo "</table>";
echo "<p> </p>";
$query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
$last_operation_name = "";
$result = mysql_query($query);
// if($result) // Result can be true even if no rows of data are returned.
// { // commented out for testing
$rexist = 1;
echo "<p><center><b>OPERATOR AND MACHINE TRACEABILITY</center></b></p>";
echo "<table>";
echo "<tr><th class='myclass'>OPERATIONS</th><th class='myclass'>Time IN</th><th class='myclass'>Time OUT</th><th class='myclass'>INPUT <br/> QTY</th><th class='myclass'>UNIT</th><th class='myclass'>OUTPUT QTY</th><th class='myclass'>UNIT</th><th class='myclass'>ID #</th><th class='myclass'>MC #</th><th class='myclass'>VARIANCE Qty</th><th class='myclass'>VARIANCE Sub Lot</th><th class='myclass'>DATE</th><th class='myclass'>SHIFT</th></tr>";
// $totalrows = mysql_num_rows($result);
$totalrows = 2; //added for testing
$trows = $totalrows - 1;
for($ctr = 0; $ctr < $trows; $ctr++)
{
$row = mysql_fetch_array($result);
$tctr = $ctr + 1;
echo "\
\ <tr>";
echo "\
\ \ <td>";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' width='400' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "\
\ <td><input type='text' name='timein[]' id='timein" . $ctr . "' onkeypress='return handleEnter(event,\\"timeout" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='timeout[]' id='timeout" . $ctr . "' onkeypress='return handleEnter(event,\\"inqty" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='inqty[]' id='inqty" . $ctr . "' onFocus='startCalc();' onBlur='stopCalc();' onkeypress='return handleEnter(event,\\"outqty" . $ctr . "\\");' /></td>";
echo "\
\ <td>" . $row["input_unit"];
echo "<input type='hidden' name='iun[]' value='" . $row["input_unit"] . "' /></td>";
echo "\
\ <td><input type='text' name='outqty[]' id='outqty" . $ctr . "' onFocus='startCalc();' onBlur='stopCalc();' onkeypress='return handleEnter(event,\\"idno" . $ctr . "\\");' /></td>";
echo "\
\ <td>" . $row["output_unit"];
echo "<input type='hidden' name='oun[]' value='" . $row["output_unit"] . "'></td>";
echo "\
\ <td><input type='text' name='idno[]' id='idno" . $ctr . "' onkeypress='return handleEnter(event,\\"mcno" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='mcno[]' id='mcno" . $ctr . "' onkeypress='return handleEnter(event,\\"varqty" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='varqty[]' id='varqty'" . $ctr . "' onkeypress='return handleEnter(event,\\"varsublot" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='varsublot[]' id='varsublot" . $ctr . "' onkeypress='return handleEnter(event,\\"dateshift" . $ctr . "\\");' /></td>";
echo "\
\ <td><input ' type='text' name='dateshift[]' id='dateshift" . $ctr . "' onkeypress='return handleEnter(event,\\"shift" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='shift[]' id='shift" . $ctr . "' onkeypress='return handleEnter(event,\\"timein" . $tctr . "\\");' /></td>";
echo "\
\ </tr>";
// } //commented out for testing
if($totalrows > 1);
{
$row = mysql_fetch_array($result);
echo "\
\ <tr>";
echo "\
\ <td >";
if ($last_operation_name != $row["operation_name"]) echo $row["operation_name"];
$last_operation_name = $row["operation_name"];
echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>";
echo "\
\ <td><input type='text' name='timein[]' id='timein" . $ctr . "' onkeypress='return handleEnter(event,\\"timeout" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='timeout[]' id='timeout" . $ctr . "' onkeypress='return handleEnter(event,\\"inqty" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\\"outqty" . $ctr . "\\");' /></td>";
echo "\
\ <td>" . $row["input_unit"];
echo "<input type='hidden' name='iun[]' value='" . $row["input_unit"] . "' /></td>";
echo "\
\ <td><input type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\\"idno" . $ctr . "\\");' /></td>";
echo "\
\ <td>" . $row["output_unit"];
echo "<input type='hidden' name='oun[]' value='" . $row["output_unit"] . "'></td>";
echo "\
\ <td><input type='text' name='idno[]' id='idno" . $ctr . "' onkeypress='return handleEnter(event,\\"mcno" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='mcno[]' id='mcno" . $ctr . "' onkeypress='return handleEnter(event,\\"varqty" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='varqty[]' id='varqty" . $ctr . "' onkeypress='return handleEnter(event,\\"varsublot" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='varsublot[]' id='varsublot" . $ctr . "' onkeypress='return handleEnter(event,\\"dateshift" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='dateshift[]' id='dateshift" . $ctr . "' onkeypress='return handleEnter(event,\\"shift" . $ctr . "\\");' /></td>";
echo "\
\ <td><input type='text' name='shift[]' id='shift" . $ctr . "' onkeypress='return handleEnter(event,\\"saveform\\");' /></td>";
echo "\
\ </tr>";
}
echo "</table>";
}
echo "<p><input type='submit' value=' Save ' id='saveform' /></p>";
echo "<input type='hidden' name='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>
<!-- Mytest: <input type="text" name="mytest" id="mytest"> -->
</form>
</body>
</html>
you haven’t posted the code in config.php so I can’t help anymore.
config.php is only the connection in database.
The error should tell you what file the error occurred in. This is important if you have several included files.
Seems that you need some curly braces after your if statement
if(mysql_num_rows($result_no) > 0 )
$clicking_input = 0;
$clicking_total = 0;