[SOLVED] PHP display checkbox val + textbox val

[klpang]

I have some dynamic checkboxes and corresponding textboxes. After input into table. How do show which check box has been check.

 

$sqltest3 = "SELECT * FROM woservice WHERE workorderID = '$workorderID' AND vas='$id'";

$resulttest3 = mysql_query($sqltest3);

$rowtest3 = mysql_fetch_array($resulttest3);

 

$sqlvas = "SELECT * FROM vas ORDER BY vasname";

$resultvas = mysql_query($sqlvas);

$rowvas = mysql_fetch_array($resultvas);

 

do

{

?>

 

 <INPUT TYPE="checkbox" NAME="vas[]" VALUE="<?php echo $rowvas["vasID"]; ?>" <?php for ($i=0; $i<count($package); $i++) { if ($package[$i]  == $rowtest3["vasID"] ) { print 'checked'; } }?>><FONT CLASS="normalText"> <?php echo $rowvas["vasname"]; ?> (<?php echo $rowvas["price"]; ?>)</FONT><INPUT TYPE="text" NAME="vasDate[<?php echo $rowvas["vasID"]; ?>]" MAXLENGTH="10" SIZE="15" ONBLUR=javascript:isDate(this.value); <?php if ($rowtest3) {?> value="<?php printf ($rowtest3["vasstartdate"]); ?>"<?php } ?>> <FONT CLASS="normalText">(dd-mm-yyyy)</FONT><BR><FONT CLASS="UserSort">Remark</FONT>  <TEXTAREA COLS="30" ROWS="3" NAME="vasremark[<?php echo $rowvas["vasID"]; ?>]"><?php echo $rowtest3["vasremark"]; ?></TEXTAREA><BR>

<?php

//}

} while ($rowtest3 = mysql_fetch_array($resulttest3))

 

After edit, how do it pass the value to next page. Please advise.

 

 

[ILMV]

God damn, use the [ code ] and [ php ] tags...

 

I'm not even going to look at this until that's done, your code is messy...

[MasterACE14]

relax ILMV, you're just abit uptight?

 

$sqltest3 = "SELECT * FROM woservice WHERE workorderID = '$workorderID' AND vas='$id'";
            $resulttest3 = mysql_query($sqltest3);
            $rowtest3 = mysql_fetch_array($resulttest3);

$sqlvas = "SELECT * FROM vas ORDER BY vasname";
      $resultvas = mysql_query($sqlvas);
      $rowvas = mysql_fetch_array($resultvas);

do
      {   
      ?>
      
             <INPUT TYPE="checkbox" NAME="vas[]" VALUE="<?php echo $rowvas["vasID"]; ?>" <?php for ($i=0; $i<count($package); $i++) { if ($package[$i]  == $rowtest3["vasID"] ) { print 'checked'; } }?>><FONT CLASS="normalText"> <?php echo $rowvas["vasname"]; ?> (<?php echo $rowvas["price"]; ?>)</FONT><INPUT TYPE="text" NAME="vasDate[<?php echo $rowvas["vasID"]; ?>]" MAXLENGTH="10" SIZE="15" ONBLUR=javascript:isDate(this.value); <?php if ($rowtest3) {?> value="<?php printf ($rowtest3["vasstartdate"]); ?>"<?php } ?>> <FONT CLASS="normalText">(dd-mm-yyyy)</FONT><BR><FONT CLASS="UserSort">Remark</FONT>  <TEXTAREA COLS="30" ROWS="3" NAME="vasremark[<?php echo $rowvas["vasID"]; ?>]"><?php echo $rowtest3["vasremark"]; ?></TEXTAREA><BR>
         <?php
      //}
         } while ($rowtest3 = mysql_fetch_array($resulttest3))

[klpang]

      $sql2 = "SELECT group_concat(vas) as vas from woservice WHERE workorderID = '$workorderID'";

      $result2 = mysql_query($sql2) or die (mysql_error());

      $row2 = mysql_fetch_array($result2);

      $package=explode(",", $row2["vas"]);

 

      $sqlvas = "SELECT * FROM vas ORDER BY vasname";

      $resultvas = mysql_query($sqlvas);

      $rowvas = mysql_fetch_array($resultvas);

do

      { 

              $sqltest3 = "SELECT * FROM woservice WHERE workorderID = '$workorderID' AND vas='$package[$i]'";

          $resulttest3 = mysql_query($sqltest3);

            $rowtest3 = mysql_fetch_array($resulttest3);      ?>

     

             <INPUT TYPE="checkbox" NAME="vas[]" VALUE="<?php echo $rowvas["vasID"]; ?>" <?php for ($i=0; $i<count($package); $i++) { if ($package[$i]  == $rowtest3["vasID"] ) { print 'checked'; } }?>><FONT CLASS="normalText"> <?php echo $rowvas["vasname"]; ?> (<?php echo $rowvas["price"]; ?>)</FONT><INPUT TYPE="text" NAME="vasDate[<?php echo $rowvas["vasID"]; ?>]" MAXLENGTH="10" SIZE="15" ONBLUR=javascript:isDate(this.value); <?php if ($rowtest3) {?> value="<?php printf ($rowtest3["vasstartdate"]); ?>"<?php } ?>> <FONT CLASS="normalText">(dd-mm-yyyy)</FONT><BR><FONT CLASS="UserSort">Remark</FONT>  <TEXTAREA COLS="30" ROWS="3" NAME="vasremark[<?php echo $rowvas["vasID"]; ?>]"><?php echo $rowtest3["vasremark"]; ?></TEXTAREA><BR>

        <?php

        } while ($rowvas = mysql_fetch_array($resultvas))

 

Thanks for the previous code.  Currently, when the check box is checked, the date and the remark doesn't show. Or missing for loop for the package? Please advise where is the erorr.