title: user ID and Dropdown sql php server side
body: <p>the code for the view page:</p>
  
  <pre><code>  &lt;table id='display'&gt;
      &lt;thead&gt;
          &lt;tr&gt;
              &lt;th&gt;ID&lt;/th&gt;
              &lt;th&gt;NAME&lt;/th&gt;
              &lt;th&gt;DEPARTMENT&lt;/th&gt;
              &lt;th&gt;TELEFON&lt;/th&gt;
              &lt;th&gt;FAKS&lt;/th&gt;
              &lt;th&gt;E-MAIL&lt;/th&gt;
              &lt;th&gt;DATA&lt;/th&gt;
              &lt;th&gt;PURPOSE&lt;/th&gt;
              &lt;th&gt;ACTION&lt;/th&gt;
          &lt;/tr&gt;
      &lt;/thead&gt;
      &lt;tbody&gt;
      &lt;?php
          $connect = mysql_connect("localhost","root","");
          if (!$connect){
              die(mysql_error());
          }
          mysql_select_db("permohonan_data");
          $option = '';
          $results = mysql_query("SELECT * FROM pemohon ORDER BY id DESC");
  
      $option .='&lt;select&gt;';
      while ($row = mysql_fetch_array($results)){
  
      ?&gt;
  
      &lt;tr&gt;
          &lt;td&gt;&lt;?php echo $row['id']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['name']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['unit']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['telefon']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['faks']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['email']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['data']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $row['purpose']?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $option .="&lt;option value='" .$row['action']. "'&gt;".$row['action']."&lt;/option&gt;"?&gt;&lt;/td&gt;
      &lt;/tr&gt;
  
  &lt;?php
  }
      $option .='&lt;/select&gt;';
  ?&gt;
  
  &lt;/tbody&gt;
  &lt;/table&gt; 
  </code></pre>
  
  <p>the ouput:</p>
  
  <p><img src="https://i.stack.imgur.com/XY03T.jpg" alt="enter image description here"></p>
  
  <p>the full detail contains id, name, position, department, institute, email, telefon and so on which doesnt show on the table because of lack of space. my question is, how when I clicked the ID number(auto increrment) of any user, I could see the full details of the user? like in a popup form?</p>
  
  <p>and my dropdown for action column are empty, supposedly have 'approve' and 'disapprove' option but I didnt know how to insert that because its for admin to valid the thing, not the user. so I can't put the option on the client side where the user is. how can I create a new client side just for admin?</p>
  
  <p>idk. please help. :(</p>