title: how to print the fetched value in mysqli prepared statement?
body: <p>MY html form :</p>
  
  <pre><code>&lt;form action="" method="post" &gt; 
  &lt;tr&gt; 
  &lt;td&gt;&lt;select name="bs_edu"&gt;
  &lt;option value="" selected="selected"&gt;Select Basic Education&lt;/option&gt;   
  &lt;option value="BA"&gt;B.A&lt;/option&gt;
  &lt;option value="BARCH"&gt;B.ARCH&lt;/option&gt;
  &lt;option value="BCA"&gt;BCA&lt;/option&gt;
  &lt;option value="BBA"&gt;BBA&lt;/option&gt; 
  &lt;/select&gt;
  &lt;td&gt;&lt;input type="text" name="desg"/&gt; &lt;/td&gt;
  &lt;td&gt;&lt;input type="email" name="email"/&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>My Query:</p>
  
  <pre><code>&lt;?php
      $stmt = $con-&gt;prepare("SELECT * FROM user_tbl WHERE bs_edu = ? AND desg = ? AND exp = ? AND pr_sal = ? AND plc = ? AND email = ?  ");
      $stmt-&gt;bind_param('ssssss', $_POST['bs_edu'], $_POST['desg'], $_POST['exp'], $_POST['prsal'], $_POST['place'], $_POST['email']);
      $stmt-&gt;execute();
      $result = $stmt-&gt;get_result();
      if ($result-&gt;num_rows &gt; "0")
      {
          while($row = $result-&gt;fetch_assoc());
          {
              echo 'first name: ' .$row['fname'];  
          }
      }
      $stmt-&gt;close(); 
  ?&gt;
  </code></pre>
  
  <p>I know this the wrong way to show the data. Going through this manual <a href="http://php.net/manual/en/mysqli-stmt.fetch.php" rel="nofollow">http://php.net/manual/en/mysqli-stmt.fetch.php</a>  n really having bad luck, show how can i show the fetched data .. any help here.. thanks</p>