dear sir,
i want to delete multiple records
through check box i am sending my code
if there is any error please check them
display the records
<input type="hidden" name="react" value="delete_user">
<?
require('header.inc');
$serchdt = '';
$serchdt = $serchdt . $myear . '-' . $mmonth . '-' . $mdate; $querystring="select * from jobsker where postdt='". $serchdt . " . and postdt no null'"; $resultrec=mysql_query($querystring, $result); $no=1; while($row = mysql_fetch_array($resultrec)) { echo "<tr>"; echo "<td width='3%' align='center'><font size='1' face='verdana , helvetica'>"; echo $no; echo ".</font></td>"; echo "<td width='3%' align='center'><font size='1' face='verdana , helvetica'>";
echo "<td><input type=\"checkbox\" name=\"id\" value=\"$id\"></td>";
echo "</font></td>"; echo "<td width='25%' align='center'><font size='1' face='verdana , helvetica'>"; echo $row["name"]; echo "</font></td>"; echo "<td width='44%' align='center'><font size='1' face='verdana , helvetica'>"; echo "<A HREF='adminedit_profileresume_.php3?" . $row["user"] ."'>" . $row["user"] . "</A>"; echo "</font></td>"; echo "<td width='25%' align='center'><font size='1' face='verdana , helvetica'>"; echo $row["postdt"]; echo "</font></td>"; echo "</tr>"; $no=$no+1;
}
?>
<p align="center"><br><input type="submit" name="b" value="Delete The Selected Item" >
delete the records
<?
if($react == "delete_user")
{
for ($i=0;$i < count($id); $i++)
{
$sql_id = $sql_id ."id=$id[$i]" . " OR ";
}
$sql_id = substr($sql_id, 0, -3);
$result = mysql_query ("DELETE FROM table WHERE $sql_id")
or die("Couldn't execute SQL query");
}
?>
is any where in problem
regards
rajeev