Delete direkte

<table border='0'>
<?
//Opretter forbindelse til databasen
$host = "";
$user = "";
$pass = "";
$db = "";
$connection = mysql_connect($host,$user,$pass);
mysql_select_db($db);

if (isset($_GET['id'])) {
    $query = mysql_query("DELETE FROM `redaktør` WHERE `id` = ".intval($_GET['id']));
}

$query = mysql_query("SELECT * FROM `redaktør` ORDER BY `id` DESC");

while ($row = mysql_fetch_array($query)) {
    echo "<tr>";
    echo "<td>".$row['navn']." - <a href=\"?id=".$row['id']."\">Slet</a></td>";
    echo "</tr>";
}
?>
</table>

<table border='0'>
<?
//Opretter forbindelse til databasen
$host = "";
$user = "";
$pass = "";
$db = "";
$connection = mysql_connect($host,$user,$pass);
mysql_select_db($db);
if(isset($_GET["id"])){
mysql_query ("DELETE FROM redaktør WHERE id='".$_GET["id"]." ORDER BY id DESC")
}
$query = mysql_query ("SELECT * FROM redaktør ORDER BY id DESC");
while ($row = mysql_fetch_array($query))  {

echo "<tr>
    <td>$row[navn] - <a href='redakslet.php?id=$row[id]'>Slet</a></td>
</tr>";

}
?>
</table>

Det skulle virke, men det er utestet :)

hov havde ikke set der var et andet svar ;)

schaefner svar tak? (:

Svar