title: How to search for record in mysql using php?
body: <p>Thanks for all your help, I now have add, update, and delete functions on my database manipulation program. 
  But I'm having difficulty on searching for records in mysql database.
  Please help me in correcting my codes, and if you know a site that I can use as my reference please do tell. Thanks, here is my search code:</p>
  
  <pre><code>         &lt;?php
        $con = mysql_connect("localhost","root","");
        if (!$con)
     {
       die('Could not connect: ' . mysql_error());
     }
  
        mysql_select_db("koro", $con);
  
       mysql_query("UPDATE student 
      WHERE IDNUMBER ='$_POST[INAME]'");
  
      while ($row = mysql_fetch_array($query)) 
      { 
        $variable1=$row["IDNUMBER"]; 
        $variable2=$row["LNAME"]; 
        $variable3=$row["FNAME"]; 
        $variable3=$row["MNAME"]; 
        $variable3=$row["GRADEYR"]; 
        $variable3=$row["ADDRESS"]; 
            } 
  
         mysql_close($con);
  
        ?&gt;
  </code></pre>
  
  <p>And here is the html form that I'm using, and I think this is where the problem is. I don't have any idea on how to put the results in the text box.</p>