title: Approve Form submit
body: <p>I have trouble with creating an approval form as am still php beginner,</p>
  
  <p>the idea is </p>
  
  <p>user submit a form am setting a default value"0" in the approved row at the table..</p>
  
  <p>so behind the scenes the admin shows all members from this table where approved="0" </p>
  
  <p>and this is the code</p>
  
  <pre><code>&lt;code&gt; 
  
      &lt;?php
      $con = mysql_connect("localhost","ebarea_epic","...");
  if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }
  
  mysql_select_db("ebarea_epic", $con);
  
  $query = "select * from medicalrep where approved='0'";
  
  $result=mysql_query($query);
  
  echo "&lt;table border='1'&gt;
  &lt;tr&gt;
  &lt;th&gt;User Name&lt;/th&gt;
  &lt;th&gt;Password&lt;/th&gt;
  &lt;th&gt;Mobile &lt;/th&gt;
  &lt;th&gt;Address&lt;/th&gt;
  &lt;th&gt;Faculty&lt;/th&gt;
  &lt;th&gt;Graduation Year&lt;/th&gt;
  &lt;th&gt;Region&lt;/th&gt;
  &lt;th&gt;Area&lt;/th&gt;
  &lt;th&gt;Line&lt;/th&gt;
  &lt;th&gt;Appointment Date&lt;/th&gt;
  &lt;th&gt;Resign Data&lt;/th&gt;
  &lt;th&gt;Job Title&lt;/th&gt;
  &lt;/tr&gt;";
  
  while($row = mysql_fetch_array($result))
    {
    echo "&lt;tr&gt;";
    echo "&lt;td&gt;" . $row['ID'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['username'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['password'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Mobile'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Address'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Faculty'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Graduation Year'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Region'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Line'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Area'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Appointment'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['Resign'] . "&lt;/td&gt;";
    echo "&lt;td&gt;" . $row['job_title'] . "&lt;/td&gt;";  
    echo "&lt;/tr&gt;";
    }
  echo "&lt;/table&gt;";
  
  mysql_close($con);
  ?&gt;
  &lt;/code&gt;
  </code></pre>
  
  <p>I just want to add checkbox for every table user and when checked thier status changed to 1 in approved column </p>
  
  <p>thanks all  </p>