Hi, I have been trying to create a functionality which allows users to delete multiple entries from database, I have been working on this for a while now but cant get my head around it, can u please tell me what im doing wrong here?
thanks in advance
[code=php]<?php
session_start();
include (“../global.php”);
//welcome messaage
$username=$_SESSION[‘username’];
echo “$username”;
$query=mysql_query(“SELECT id FROM users WHERE username=’$username'”);
while($row = mysql_fetch_assoc($query))
{
$user_id = $row[‘id’];
echo $id;
}
$per_page=5;
$start=$_GET[‘start’];
$record_count =mysql_num_rows(mysql_query(“SELECT * FROM rent”));
?>
<td><form name=”form1″ method=”post” action=””> </td>
<?php
$max_page=$record_count/$per_page;
if(!$start)
$start=0;
$result= mysql_query(“SELECT id, msg, title, reference FROM msg LIMIT $start, $per_page”);
while($row = mysql_fetch_array($result))
{
$id=$row[‘id’];
$msg=$row[‘msg’];
$reference=$row[‘reference’];
$title=$row[‘title’];
?>
<table>
<tr>
<td align=”center” bgcolor=”#FFFFFF”><input name=”checkbox[]” type=”checkbox” id=”checkbox[]” value=”<? echo $rows[‘id’]; ?>”></td>
<td><?php echo $title; ?></td>
<td><?php echo $id; ?></td>
<td><?php echo $reference; ?></td>
<td><?php echo $msg; ?></td>
</tr>
</table>
<tr>
<td colspan=”5″ align=”center” bgcolor=”#FFFFFF”><input name=”delete” type=”submit” id=”delete” value=”Delete”></td>
</tr>
<?php
//while
}
$prev=$start – $per_page;
$next=$start + $per_page;
if(!($start<=0))
echo “<a href=’view-data.php?start=$prev’>Previous</a>”;
if(!($start>=$record_count-$per_page))
echo “<a href=’view-data.php?start=$next’>Next</a>”;
if(isset($_POST[‘delete’]))
{
for($i = 0; $i <= count($_POST[‘checkbox’]); $i++)
{
$del_id = $checkbox[$i];
$sql = “DELETE FROM rent WHERE id=’$del_id'”;
$result = mysql_query($sql);
}
if($result)
{
header(‘Location: view-data.php’);
}
}
?>
</table>
</form>