Code: Select all
//Deleting part
if (isset($_POST['submitButton']))
{
$topic_to_delete = $_POST['topicCategory'];
$sql = "DELETE FROM topics WHERE topicID = '$topic_to_delete' ";
mysql_query($sql);
}
//Displaying part
$sql = "SELECT
topicID
topicSubject,
topicDate,
topicCategory,
topicByUser
FROM
topics";
$result = mysql_query($sql);
echo '<form method="post" action="">
Topic:';
echo '<select name="topicCategory">';
while($row = mysql_fetch_assoc($result))
{
echo '<option value="' . $row['topicID'] . '">' . $row['topicCategory'] . '</option>';
}
echo '</select><br />';
echo ' <input type="submit" value="Delete topic" name="submitButton" />
</form>';
Code: Select all
echo '<option value="' . $row['topicID'] . '">' . $row['topicCategory'] . '</option>';Code: Select all
$topic_to_delete = $_POST['topicCategory'];Hope someone can help