Checkbox problemer
Jeg har altid så stor "fornøjelse" når jeg laver checkboxes.Jeg vil gerrne slette en record fra min database ved hjælp af en checkbox.
Min kode:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
</head>
<body>
<form action="" method="post" name="" id="">
<?php
include("conn.php");
$sql="select * from $branch order by sn";
$result=mysql_query($sql,$connection) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
echo '<input type="checkbox" name="ref[]" value="$row['.sn.']">';
echo $row['titel'];
echo $row['kortbeskr'];
}
echo '<input type="submit" name="submit">';
echo '</form>';
if(isset($submit)) {
if ( count( $_POST['ref'] ) > 0 )
{
$ids = join( ",", $_POST['ref'] );
$sql="delete from $branch where sn='$ids'";
$result=mysql_query($sql) or die(mysql_error());
}
}
?>
</body>
</html>
- men der sker intet.
