I have a table of names with a checkbox in each row.
http://webdesign4.georgianc.on.ca/~1.../wi/guests.php
I want to to be able to check multiple boxes and move them to an identical table called 'confirmed'.
Here is my table php
PHP Code:
/*open db connection*/
$conn = mysqli_connect('localhost', 'db100116763', '15943', 'db100116763') or die('Error connecting to MySQL server.');
/*retrieve all properties*/
$sql = "SELECT * FROM guests";
$result = mysqli_query($conn, $sql) or die('Error querying database.');
echo '<form><table border="1"><tr><td>ID</td><td>First Name</td><td>Last Name</td><td>Email Address</td><td>Select</td></tr>';
//loop through properties and output them to an html table
while ($row = mysqli_fetch_array($result)) {
echo '<tr><td>' . $row['id'] . '</td>
<td>' . $row['first_name'] . '</td>
<td>' . $row['last_name'] . '</td>
<td>' . $row['email'] . '</td> ';
echo '<td><input type="checkbox" name="mychk[]"></input></td>';
}
echo '</table></form>';
echo '<a href="delete.php?id=' . $row['id'] . '">Move</a>';
mysqli_close($conn);
Before you post, read our: 
