How to add a delete button to this

[Jedijon]

<?php
$con=mysqli_connect("IP","Username","Password","Database");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = mysqli_query($con,"SELECT * FROM support");

echo "<table border='1'>
<tr>
<th>Name</th>
<th>Email</th>
<th>Priority</th>
<th>Type</th>
<th>Subject</th>
<th>Message</th>
</tr>";

while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['email'] . "</td>";
echo "<td>" . $row['priority'] . "</td>";
echo "<td>" . $row['type'] . "</td>";
echo "<td>" . $row['subject'] . "</td>";
echo "<td>" . $row['message'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

[requinix]

Quote

How to add a delete button to this

I suggest using code.

Try it yourself. If you have specific questions or problems then post what you've done for it.

[Jedijon]

Thank you for all the help

[requinix]

FYI sarcasm doesn't translate well over the internet unless you lay it on really thick.

Don't know where to start? Wrap the whole table in a <form> that will post back to this same page. In each row, add a <button> named "delete" with a value that is unique for the row - so you know what to delete.

To handle the delete, check $_POST for the delete button. If present you'll know which row to delete. Delete it.

[Jedijon]

Thank you I figure it out