Hello All,
I am trying to delete multiple records in PHP.
It displays the list of recordfs ok but when i click delete it will not delete anything.
Can anyone help before this drives me up the wall and around the bend!!
Cheers
<?php require_once('../Connections/classified.php'); ?>
<?php
$maxRows_deleteticked = 50;
$pageNum_deleteticked = 0;
if (isset($_GET['pageNum_deleteticked'])) {
$pageNum_deleteticked = $_GET['pageNum_deleteticked'];
}
$startRow_deleteticked = $pageNum_deleteticked * $maxRows_deleteticked;
mysql_select_db($database_classified, $classified);
$query_deleteticked = "SELECT ID, Title, Description, `date`, image FROM classifieds";
$query_limit_deleteticked = sprintf("%s LIMIT %d, %d", $query_deleteticked, $startRow_deleteticked, $maxRows_deleteticked);
$deleteticked = mysql_query($query_limit_deleteticked, $classified) or die(mysql_error());
$row_deleteticked = mysql_fetch_assoc($deleteticked);
if (isset($_GET['totalRows_deleteticked'])) {
$totalRows_deleteticked = $_GET['totalRows_deleteticked'];
} else {
$all_deleteticked = mysql_query($query_deleteticked);
$totalRows_deleteticked = mysql_num_rows($all_deleteticked);
}
$totalPages_deleteticked = ceil($totalRows_deleteticked/$maxRows_deleteticked)-1;
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="<?php echo $PHP_SELF?>">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">#</td>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Tile</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
</tr>
<?php do { ?>
<tr>
<td align="center" bgcolor="#FFFFFF"><input type="Checkbox" name="deleterecord[]" value="<?php echo $row_deleteticked['ID']; ?>"></td>
<td bgcolor="#FFFFFF"><?php echo $row_deleteticked['ID']; ?><?php echo $row['ID']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $row['Title']; ?></td>
<td bgcolor="#FFFFFF"></td>
<td bgcolor="#FFFFFF"></td>
</tr>
<?php } while ($row_deleteticked = mysql_fetch_assoc($deleteticked)); ?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="delete"></td>
</tr>
//<?php
// Check if delete button active, start this
$sql="SELECT * FROM $classifieds";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
$delete = $_POST['delete'];
if ($delete){
for($i=0;$i<$count;$i++){
$del_id = $_POST['deleterecord[$i]'];
echo $del_id;
$sql1 = "DELETE FROM $classifieds WHERE ID='$del_id'";
$result1 = mysql_query($sql1);
}
// if successful redirect to delete_multiple.php
if($result1){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>
<?php
mysql_free_result($deleteticked);
?>
