title: assigning php variable value from html table cell
body: <p>I am trying to make a table which displays logs for users that have logged in to the system.
  The logs are working perfectly,but i want the tables on the final table column to lead me to the member's information.
  Assigning the member id column value for individual rows so i can use them as 'WHERE' in the queries is the problem</p>
  
  <p>Note
  The member_id column is a foreign key that links to the member information table
  the member details on the other hand are in another table where the member_id is a primary key
  The buttons should take me to the member's information using the member_id of the table row that the button is in
      
  
  <pre><code>echo "&lt;table border = 2&gt;"; // start a table tag in the HTML
  
  echo "&lt;tr&gt;
           &lt;td&gt;Member ID&lt;/td&gt;
           &lt;td&gt;Date&lt;/td&gt;
           &lt;td&gt;Time&lt;/td&gt;
           &lt;td&gt;Member Info&lt;/td&gt;
     &lt;/tr&gt;";
  while($row = mysql_fetch_array($result)){   //Creates a loop to loop through results
    echo "&lt;tr&gt;
            &lt;td&gt;" . $row['member_id'] . "&lt;/td&gt;
            &lt;td&gt;" . $row['date'] . "&lt;/td&gt;
            &lt;td&gt;" . $row['time'] . "&lt;/td&gt;
            &lt;td&gt;&lt;input type= 'submit' value = 'Member Information' onsubmit ='memberinfo.php'&gt;&lt;/td&gt;
             //this button is the one to open member information
  &lt;/tr&gt;";
  }
  
  echo "&lt;/table&gt;"; //Close the table in HTML
  
  mysql_close(); 
   ?&gt;
  </code></pre>