Hopelijk kan iemand mij helpen.
Ik heb onderstaand tabelletje met op iedere regel een checkbox om een regel te kunnen verwijderen uit de database.
Maar als ik nu op de Delete knop druk doet hij wel de pagina verversen, maar de regel is niet verwijderd.
Ik krijg ook geen verdere foutmeldingen.
Bij voorbaat dank.
<?php
$tbl_name="table_500"; // Table name
$result = mysql_query("SELECT * FROM $tbl_name")
or die(mysql_error());
echo "<form name='form1' method='post' action=''>";
echo "<table id='cashbook' width='100%' cellpadding='1' border='0'>";
echo "<thead><tr>
<th>Date</th>
<th>Description</th>
<th>Income</th>
<th>Expense</th>
<th> </th>
</tr></thead>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr>
<td width='25%'>";
echo $row['field68'];
echo "</td><td width='50%'>";
echo $row['field70'];
echo "</td><td width='10%'>";
echo $row['field69'];
echo "</td><td width='10%'>";
echo $row['field71'];
echo "</td><td width='5%'><input name='checkbox[]' type='checkbox' session_id='checkbox[]' value='";
echo $row['session_id'];
echo "'></td></tr>";
}
echo "</table>";
echo "<hr />";
echo "<input name='delete' type='submit' session_id='delete' value='Delete'>";
// Check if delete button active, start this
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE session_id='$del_id'";
$result = mysql_query($sql);
}
// if successful redirect
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=\cashbook.php\">";
}
}
echo "</form>";
?>
3.289 views
