View Single Post
  #2 (permalink)  
Old February 14th, 2011, 05:13 AM
newphpcoder newphpcoder is offline
Registered User
 
Join Date: Dec 2010
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Good day!

I tried to resolved my problem by tracing the codes and I trace it but I tried to resolved but nothing has change in my output still the 04 Oper was duplicated.

Here is the code where i think I have problem:

PHP Code:
                   

//If not existing the form will appear to insert data.

                    
if($rexist == 0)
                        {
                        
$query "SELECT t.operation_name, t.input_unit, t.output_unit FROM trace_operations t WHERE t.plt_typeno = '" $_POST["plt_typeno"] . "'  AND t.operation_name IN('02 Oper','03 Oper','04 Oper') ORDER BY t.operation_name";
                      


                        
$last_operation_name "";
                        
$result mysql_query($query);
                        if(
$result){

//in this code I think I have a problem why the last operation name was duplicated, but I have no idea how can i resolved it. I'm not good in analyzing and in the syntax condition code.

//in this code happened is the last operation_name was fetch in this for loop and also in the if condition below so it was duplicated. I want to happened is in the last operation name in false on the if condition so that it could not duplicated.
                       
$totalrows mysql_num_rows($result);
                       
$trows $totalrows 1;
                          for(
$ctr 0$ctr $trows$ctr++)
                           {
                          
$tctr $ctr 1;
                          
$row mysql_fetch_array($result);                          
                           echo 
"\n\t<tr>";
                           echo 
"\n\t\t<td width='800'>";
                           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='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                          
                           echo 
"\n\t\t<td><input size='6' type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></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>" $row["input_unit"];
                            echo 
"<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                            
                            echo 
"\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td>" $row["output_unit"];
                            echo 
"<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                            
                            echo 
"\n\t\t<td><input size='6' type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                           
                           echo 
"\n\t\t<td><input size='6' type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                           
                            echo 
"\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" $ctr "' onkeypress='return handleEnter(event,\"varplt" $ctr "\");' /></td>";
                           
                            echo 
"\n\t\t<td><input size='6' type='text' name='varplt[]' id='varplt" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                            
                            echo 
"\n\t\t<td><input size='6' type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift" $ctr "\");' /></td>";
                            
                           echo 
"\n\t\t<td><input size='6' type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"timein" $tctr "\");' /></td>";
                            echo 
"\n\t</tr>";

                            }
                            
                        }
                       if(
$totalrows 0);
                            {
                            
$row mysql_fetch_array($result);
                            echo 
"\n\t<tr>";
                            echo 
"\n\t\t<td width='800'>";
                            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='timein[]' id='timein" $ctr "' onkeypress='return handleEnter(event,\"timeout" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='timeout[]' id='timeout" $ctr "' onkeypress='return handleEnter(event,\"inqty" $ctr "\");' /></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>" $row["input_unit"];
                            echo 
"<input type='hidden' name='iun[]' value='" $row["input_unit"] . "' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='outqty[]' id='outqty" $ctr "' onkeypress='return handleEnter(event,\"idno" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td>" $row["output_unit"];
                            echo 
"<input type='hidden' name='oun[]' value='" $row["output_unit"] . "'></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='idno[]' id='idno" $ctr "' onkeypress='return handleEnter(event,\"mcno" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='mcno[]' id='mcno" $ctr "' onkeypress='return handleEnter(event,\"varqty" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='varqty[]' id='varqty" $ctr "' onkeypress='return handleEnter(event,\"varplt" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='varplt[]' id='varplt" $ctr "' onkeypress='return handleEnter(event,\"dateshift" $ctr "\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='dateshift[]' id='dateshift" $ctr "' onkeypress='return handleEnter(event,\"shift\");' /></td>";
                            echo 
"\n\t\t<td><input size='6' type='text' name='shift[]' id='shift" $ctr "' onkeypress='return handleEnter(event,\"saveform\");' /></td>";
                            echo 
"\n\t</tr>";
                            }
                        echo 
"</table>";
                        echo 
"<p><input type='submit' value='Save' id='saveform' /></p>";
                        echo 
"<input type='hidden' name='plt_typeno' value='" $_POST["plt_typeno"] . "' />";
                        }  
                       
                        
                    } 
Reply With Quote