title: how to get the value of href in table row?
body: <p>My first work is here.
  They search for the name and display the table of such names.
  I'm using another text field to get the ID number of applicants to display their profile.
  Now, I want to do it by just clicking their ID number which is on the table row.
  I tried this code but seems it doesn't work.</p>
  
  <pre><code>&lt;?php
  $sql = mysql_query("select * from applicant_data")
     or die('Error in query : $sql. ' .mysql_error());
  
  if (mysql_num_rows($sql) &gt; 0) 
  {            
  
  while ($row = mysql_fetch_array($sql)){
  
  ?&gt;                  
  &lt;tr&gt;
  &lt;td align="center" bgcolor="#ffffff"&gt;&lt;form method="post" action="psp_view_profile.php" name="submit" &gt;
  &lt;?php echo '&lt;a href="psp_view_profile.php?$no="&gt; ' . $row['id'] . '&lt;/a&gt;'?&gt;&lt;/td&gt;&lt;/form&gt;
  &lt;td align="center" bgcolor="#ffffff"&gt;&lt;?php echo $row['lastname']; ?&gt;&lt;/td&gt;
  &lt;td align="center" bgcolor="#ffffff"&gt;&lt;?php echo $row['firstname']; ?&gt;&lt;/td&gt;
  &lt;td align="center" bgcolor="#ffffff"&gt;&lt;?php echo $row['middlename']; ?&gt;&lt;/td&gt;
  
  &lt;?php
  }
  }
  ?&gt;
  </code></pre>
  
  <p>And this one is from psp_view_profile.php</p>
  
  <pre><code>&lt;?php
  include('config.php');
  $no = $_POST['no'];
      $sql1 = mysql_query("SELECT * FROM applicant_data WHERE id='$no'");
  
      while($_GET = mysql_fetch_array($sql1)){
  
      $Date = $_GET["datapply"];
      $FirstName = $_GET["firstname"];
      $MiddleName = $_GET["middlename"];
      $LastName = $_GET["lastname"];
      $RStreet = $_GET['res_st'];
      $RBarangay = $_GET['barangay'];
   //and so on...
  </code></pre>