php - Presenting/editing checkbox values? -

hi baffling me because checkboxes in form textboxes also. enter following database new record:

<form action="processmem.php" method="post">     <table width="800" align="center">         <tr>             <td width="99" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>             <td width="100" height="2">&nbsp;</td>         </tr>         <tr>             <td colspan="3" align="right" height="30">                 name&nbsp;&nbsp;             </td>             <td colspan="2" align="left">                 <input type="text" name="textfield[childname]" />             </td>             <td colspan="3"><p>&nbsp;</p><p>&nbsp;</p></td>         </tr>         <tr>             <td colspan="3" align="right" height="30">                 age&nbsp;&nbsp;             </td>             <td colspan="2" align="left">                 <input type="text" name="textfield[age]" />             </td>             <td colspan="3"><p>&nbsp;</p><p>&nbsp;</p></td>         </tr>         <tr>             <td colspan="3" align="right" height="30">                 parent name&nbsp;&nbsp;             </td>             <td colspan="2" align="left">                 <input type="text" name="textfield[parentname]" />             </td>             <td colspan="3"><p>&nbsp;</p><p>&nbsp;</p></td>         </tr>         <tr>             <td colspan="3" align="right" height="30">                 email address&nbsp;&nbsp;             </td>             <td colspan="2" align="left">                 <input type="text" name="textfield[email]" />             </td>             <td colspan="3"><p>&nbsp;</p><p>&nbsp;</p></td>         </tr>         <tr>             <td colspan="3" align="right" height="30">                 contact number&nbsp;&nbsp;             </td>             <td colspan="2" align="left">                 <input type="text" name="textfield[contactno]" />             </td>             <td colspan="3">&nbsp;</td>         </tr>         <tr>             <td colspan="8" height="30">&nbsp;</td>         </tr>         <tr>             <td height="15" colspan="2">&nbsp;</td>             <td colspan="3" align="right">&nbsp;&nbsp;</strong>                 check box if member  ninja!             </td>             <td align="center">                 <input type="checkbox" name="checkbox[ninja]" value="checkbox" />             </td>             <td colspan="2">&nbsp;</td>         </tr>         <tr>             <td colspan="8" height="30">&nbsp;</td>         </tr>         <tr>             <td height="15" colspan="2">&nbsp;</td>             <td colspan="4" align="center">                 subjects has member attended?             </td>             <td colspan="2"></td>         </tr>         <tr>             <td height="5" colspan="8">&nbsp;</td>         </tr>         <tr>             <td height="15">&nbsp;</td>             <td colspan="2" align="center">scratch</td>             <td colspan="2" align="center">app inventor</td>             <td colspan="2" align="center">html</td>             <td>&nbsp;</td>         </tr>         <tr>             <td height="15">&nbsp;</td>             <td colspan="2" align="center">                 <input type="checkbox" name="checkbox[scratch]" value="checkbox" />             </td>             <td  colspan="2" align="center">                 <input type="checkbox" name="checkbox[appinventor]" value="checkbox" />             </td>             <td colspan="2" align="center">                 <input type="checkbox"  name="checkbox[html]" value="checkbox" />             </td>             <td>&nbsp;</td>         </tr>     </table> </form> 

it's execeuted script:

<?php  include("connect.php"); require_once("logincheck.php");  if(isset($_post)){  $childname=mysql_real_escape_string($_post['textfield']['childname']); $age=mysql_real_escape_string($_post['textfield']['age']); $parentname=mysql_real_escape_string($_post['textfield']['parentname']); $email=mysql_real_escape_string($_post['textfield']['email']); $contactno=mysql_real_escape_string($_post['textfield']['contactno']); $ninja=isset($_post['checkbox']['ninja'])?'yes':'no'; $scratch=isset($_post['checkbox']['scratch'])?'yes':'no'; $appinventor=isset($_post['checkbox']['appinventor'])?'yes':'no'; $html=isset($_post['checkbox']['html'])?'yes':'no';  $sql="insert tblmembers (childname, age, parentname, email, contactno, ninja, scratch,  appinventor, html) values ('$childname','$age','$parentname','$email','$contactno', '$ninja','$scratch','$appinventor','$html')";mysql_query($sql) or die (mysql_error());  } 

this works fine, cannot see value of checkboxes if query record later, here:

$id=$_get["id"];  $sql="select * tblmembers id=".$id;  $result=mysql_query($sql);  $rows=mysql_num_rows($result);  while($row =mysql_fetch_array($result)) {  $childname=$row["childname"]; $id=$row["id"]; $age=$row["age"]; $parentname=$row["parentname"]; $email=$row["email"]; $contactno=$row["contactno"]; $ninja=$row["checkbox"]["ninja"]; $scratch=$row["checkbox"]["scratch"]; $appinventor=$row["checkbox"]["appinventor"]; $html=$row["checkbox"]["html"];  print "<p align=\"center\"><strong><i>information $childname</i><strong></p><br>"; print "<table width=\"800\" align=\"center\">";          print "<tr>"; print "<td width=\"99\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">name&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[childname]\"  value='".$childname."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">age&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield  [age] "value='".$age."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">parent name&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[parentname]\"   value='".$parentname."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">email address&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[email]\"   value='".$email."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">contact number&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[contactno]\"  value='".$contactno."'/></td>"; print "<td colspan=\"3\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"8\" height=\"30\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\" colspan=\"2\">&nbsp;</td>"; print "<td colspan=\"3\" align=\"right\">&nbsp;&nbsp;</strong>check box if  member  ninja!</td>"; print "<td align=\"center\"><input type=\"checkbox\" name=\"checkbox[ninja]\" value=$row   [\"ninja\"]/></td>"; print "<td colspan=\"2\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"8\" height=\"30\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\" colspan=\"2\">&nbsp;</td>"; print "<td colspan=\"4\" align=\"center\">which subjects has member attended?</td>"; print "<td colspan=\"2\"></td>"; print "</tr>"; print "<tr>"; print "<td height=\"5\" colspan=\"8\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\">&nbsp;</td>"; print "<td colspan=\"2\" align=\"center\">scratch</td>"; print "<td colspan=\"2\" align=\"center\">app inventor</td>"; print "<td colspan=\"2\" align=\"center\">html</td>"; print "<td>&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\">&nbsp;</td>"; print "<td colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[scratch]\"  value='".$scratch."' /></td>"; print "<td  colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[appinventor] \" value='".$appinventor."' /></td>"; print "<td colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[html]\"  value='".$html."' /></td>"; print "<td>&nbsp;</td>"; print "</tr>"; print "</table>"; }  ?> 

finally - if cannot see checkbox checked on entering database, cannot edit or update record. i'm using this:

$id=$_get["id"];  include("connect.php"); require_once("logincheck.php");  if($_get["function"]=='update')  {  $childname=mysql_real_escape_string($_post['textfield']['childname']); $age=mysql_real_escape_string($_post['textfield']['age']); $parentname=mysql_real_escape_string($_post['textfield']['parentname']); $email=mysql_real_escape_string($_post['textfield']['email']); $contactno=mysql_real_escape_string($_post['textfield']['contactno']); $ninja=isset($_post['checkbox']['ninja'])?'yes':'no'; $scratch=isset($_post['checkbox']['scratch'])?'yes':'no'; $appinventor=isset($_post['checkbox']['appinventor'])?'yes':'no'; $html=isset($_post['checkbox']['html'])?'yes':'no';  $sql2="update tblmembers set  childname='".$childname."',age='".$age."',parentname='".$parentname."', email='".$email."',contactno='".$contactno."',ninja='".$ninja."',scratch='".$scratch."', appinventor='".$appinventor."',html='".$html."' id=".$id;  mysql_query($sql2) or die (mysql_error());  print "<strong>the member details have been saved. thank you.</strong><br><br><br>"; } else {  $sql="select * tblmembers id=".$id;  $result = mysql_query ($sql) or die(mysql_error());  $rows=mysql_num_rows($result);  while($row =mysql_fetch_array($result)) {  $childname=$row["childname"]; $id=$row["id"]; $age=$row["age"]; $parentname=$row["parentname"]; $email=$row["email"]; $contactno=$row["contactno"]; $ninja=$row["ninja"]; $scratch=$row["scratch"]; $appinventor=$row["appinventor"]; $html=$row["html"];  print "<form method=post action='editmember.php?function=update'>"; print "<table width=\"800\" align=\"center\">";          print "<tr>"; print "<td width=\"99\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "<td width=\"100\" height=\"2\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">name&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[childname]\"  value='".$childname."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">age&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[age]\"  value='".$age."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">parent name&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[parentname]\"  value='".$parentname."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">email address&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[email]\"  value='".$email."'/></td>"; print "<td colspan=\"3\"><p>&nbsp;</p><p>&nbsp;</p></td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"3\" align=\"right\" height=\"30\">contact number&nbsp;&nbsp;</td>"; print "<td colspan=\"2\" align=\"left\"><input type=\"text\" name=\"textfield[contactno]\"  value='".$contactno."'/></td>"; print "<td colspan=\"3\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"8\" height=\"30\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\" colspan=\"2\">&nbsp;</td>"; print "<td colspan=\"3\" align=\"right\">&nbsp;&nbsp;</strong>check box if  member   ninja!</td>"; print "<td align=\"center\"><input type=\"checkbox\" name=\"checkbox[ninja]\"  value='".$ninja."' /></td>"; print "<td colspan=\"2\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td colspan=\"8\" height=\"30\">&nbsp;</td>";  print "</tr>"; print "<tr>"; print "<td height=\"15\" colspan=\"2\">&nbsp;</td>"; print "<td colspan=\"4\" align=\"center\">which subjects has member attended?</td>"; print "<td colspan=\"2\"></td>"; print "</tr>"; print "<tr>"; print "<td height=\"5\" colspan=\"8\">&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\">&nbsp;</td>"; print "<td colspan=\"2\" align=\"center\">scratch</td>"; print "<td colspan=\"2\" align=\"center\">app inventor</td>"; print "<td colspan=\"2\" align=\"center\">html</td>"; print "<td>&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td height=\"15\">&nbsp;</td>"; print "<td colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[scratch]\"  value='".$scratch."' /></td>"; print "<td  colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[appinventor] \" value='".$appinventor."' /></td>"; print "<td colspan=\"2\" align=\"center\"><input type=\"checkbox\"  name=\"checkbox[html]\"    value='".$html."' /></td>"; print "<td>&nbsp;</td>"; print "</tr>"; print "<tr>"; print "<td><input type=hidden name=id value=".$id."><br></td>"; print "<td colspan=\"4\" align=\"center\"><input type=submit  value='&nbsp;save&nbsp;'></td></form>"; print "<td td colspan=\"4\" align=\"center\"><form method='post' name='cancel'   action='memberinfo.php?id=".$id."'><input type='submit' value='&nbsp;cancel&nbsp;'></form></td>"; print "</tr>"; print "</table>";  }  }  ?> 

i hope can help! i've gotten great here before , beginner php. please forgive typos or errors.

i need able display record entered, go in, edit , save updated record db. in advance...