Oke, I want to delete a record in a SQL database. But it seems the query is not coming trough.. I keep getting the "or die" message when "triggering" $result. I don't understand whats wrong with the code, can someone help me? 🙂
<?php
if ($submit) {
mysql_connect("localhost", "***", "***") or die("Niet gelukt om een verbinding met de MySQL-server te maken...");
mysql_select_db("***") or die("Niet gelukt om een database te selecteren...");
$sql = "DELETE FROM List (id) WHERE id = '$id'";
$result = mysql_query($sql) or die("Niet gelukt om record the verwijderen.");
echo "Record verwijderd.\n";
} else{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
Server ID:<input type="Text" name="id"><br>
<input type="Submit" name="submit" value="Ok">
</form>
<?php
} // end if
?>
