Error: Expected ;

newphpcoder

Good day!

I encountered an error at line 26, error: expected ';'

I can't see what is the cuase of that error.

<?php

include 'config.php';
$rexist = 0;
if($_POST["clt_no"])
{
   $opname = $_POST["opname"];
   $inqty = $_POST["inqty"];
   $outqty = $_POST["outqty"];

   $totalarr = count($opname) - 1;
    for($ctr=0; $ctr < $totalarr; $ctr++)
        {
        $inqty[$ctr] = (float) $inqty[$ctr];
        $outqtyqty[$ctr] = (float) $outqty[$ctr];

     $query = "INSERT INTO clt_traceability (operation_name, input_qty, clt_transact_id) VALUES ('" . $opname[$ctr] . "',  '" . $inqty[$ctr] . "', '" . $outqty[$ctr] . "', '" . $clt_transact_id . "')";
    $result = mysql_query($query);
    }   

$query = "SELECT * FROM clt_transact WHERE  clt_no = '" . $_POST["clt_no"] . "'";
$result_no = mysql_query($query);
    if($result_no)
        {
        if(mysql_num_rows($result_no) > 0 )
        $clicking_input = 0;
        $clicking_total = 0;

        $query = "SELECT t.input_qty AS clicking_input FROM clt_traceability t, p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name '02 Clicking' AND p.clt_no='" . $_POST["clt_no"] . "'";
        $resultyield = mysql_query($query);
        if($resultyield)
            {
                if(mysql_num_rows($resultyield) > 0)$clicking_input =mysql_result($resultyield,0,"clicking_input");
            }
      /*  $query = "SELECT SUM(t.input_qty) AS clicking_input FROM clt_traceability t, clt_transact p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name '02 Clicking' AND p.clt_no='" . $_POST["clt_no"] . "'";
        $resultyield = mysql_query($query);
        if($resultyield)
            {
                if(mysql_num_rows($resultyield) > 0)$clicking_input =mysql_result($resultyield,0,"clicking_input");
            }*/
        $query = "SELECT operation_name FROM clt_traceability t, clt_transact c WHERE t.operation_name = '02 Clicking Total' AND t.clt_transact_id = c.clt_transact_id";
        $result = mysql_query($query);
        if($result > 0)
        {           
        $clicking_total = $clicking_input;
        //pano automatic mag eecho o mag aappear ung sum ng inqty sa inqty ng clicking total
        }
        }
}
$rexist = 0;
?>

<html>
<head>
    <style type="text/css">
    .myclass {
     font-size: 10pt; font-family:Arial, Helvetica, sans-serif;
    }
    </style>

<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;
        }
    }
</script>
</head>
<body onLoad="document.clttest.clt_no.focus();">
<form action='test5.php' method="post" name="clttest">
<?php
    $rexist = 1;

$query = "SELECT * FROM clt_trace_operations ORDER BY operation_name";
$last_operation_name = "";
$result = mysql_query($query);
if($result)
    {
    $rexist = 1;

    echo "<table>";
    echo "<tr><th>Operation</th><th>Inqty</th><th>Outqty</th></tr>";
     $totalrows = mysql_num_rows($result);
    $trows = $totalrows - 1;
    for($ctr = 0; $ctr < $trows; $ctr++)
        {
        $row = mysql_fetch_array($result);
        $tctr = $ctr + 1;
        echo "\n\t<tr>";
        echo "\n\t\t<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 "\n\t\t<td><input size='6' type='text' name='inqty[]' id='inqty" . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>";
         echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"inqty" . $tctr . "\");' /></td>";
        echo "\n\t</tr>";
        }
    if($totalrows > 1);
        {
        $row = mysql_fetch_array($result);
        echo "\n\t<tr>";
        echo "\n\t\t<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 "<input type='hidden' name='opname[]' value='" . $row["operation_name"] . "' /></td>"; 
        echo "\n\t\t<td><input size='6' type='text' name='inqty[]' value='$clicking_total' id='inqty"  . $ctr . "' onkeypress='return handleEnter(event,\"outqty" . $ctr . "\");' /></td>";
        echo "\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" . $ctr . "' onkeypress='return handleEnter(event,\"saveform" . $ctr . "\");' /></td>";
        echo "\n\t</tr>";
        }
    echo "</table>";
    }       
echo "<p><input type='submit' value='  Save  ' id='saveform' /></p>";
echo "<input type='hidden' name='clt_typeno' value='" . $_POST["clt_typeno"] . "' />";
?>

Thank you

bradgrafelman

There's no need to attach the file.. just insert into into your post using the appropriate bbcode tags.

Also, there are no parse errors in the code you posted.

JVassie

It would also be a lot easier to read if you used braces for every if, while, for loop etc you use, eg.

if(mysql_num_rows($result_no) > 0 )
            $clicking_input = 0;
            $clicking_total = 0;

should really be

if(mysql_num_rows($result_no) > 0 )
{
            $clicking_input = 0;
            $clicking_total = 0;
}

and also indenting the code helps to make it easy to read, and more likely for others to help 🙂

As bradgrafelman said, there are no parse errors, your line 26 terminates with a ; are you sure you uploaded the file after you last made changes to it?