html table with button call popup box with drop down list

daniel0816 · September 3, 2013

I am trying to get the update button in the html table to call up a pop up box with a drop down list in it with an exit button that closes the pop up box.

Below is the code I have so far:

<html>
<body>
<?php
error_reporting(E_ALL);
$connect = mysql_connect("dbinfo", "dbinfo", "dbinfo");
//select database
mysql_select_db("dbinfo", $connect);

$select = "SELECT * FROM JobStatus";
$result = mysql_query($select);
if($result)
{
?>
<table border="2">
<thead>
<tr>
  <th>Job Status ID</th>
  <th>Job Reference Number</th>
  <th>Job Status</th>
  <th>Update?</th>
</tr>
</thead>
<tbody>
<?php
}
  if(mysql_num_rows($result)==0)
  {
   echo '<tr><td colspan="4">No Rows Returned</td></tr>';
  }
  else
  {
   while($row = mysql_fetch_assoc($result))
   {
    echo "<tr>
      <td>{$row['JS_ID']}</td>
      <td>{$row['J_RefNum']}</td>
      <td>{$row['JS_Status']}</td>
      <td><button name=update class=updatebtn>Update Status</button></td>
      </tr>\n";
   }
?>
</tbody>
</table>
<?php
}
?>
</body>
</html>

Any help would be greatly appreciated thanks

Sign In

html table with button call popup box with drop down list

Recommended Posts

daniel0816

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information