Не удаляется запись. не могу понять почему?
| Код |
<?php
if ( isset ( $_POST['item'] ) )
{
$ids = implode( ',', $_POST['item'] );
$query = 'DELETE FROM kandidat WHERE id IN ('.$ids.')';
mysql_query( $query );
header( 'Location: '.$_SERVER['PHP_SELF'] );
}
?>
<?php
$per_page=15;
if (isset($_GET['page'])) $page=($_GET['page']-1); else $page=0;
$start=abs($page*$per_page);
$q = "SELECT * FROM `kandidat` ORDER BY data DESC LIMIT $start, $per_page";
$sql = mysql_query($q);
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="POST">';
echo '<input type="submit" name="submitForm" value="Удалить отмеченные"><br><br>';
echo "<table border='1' cellspacing='0' cellpadding='5'>";
echo "<tr><th>Фото</th><th>Резюме</th><th>Город</th><th>www</th><th>Удл</th><th>Дата</th><th>file</th></tr>";
while ($result = mysql_fetch_array($sql))
{
echo "<tr>
<td>";
$photo = "<img src = 'file/". $result[photo]."' height='95' width='75'/>";
switch($result['photo'] or NULL)
{
case 1:
echo $photo;
break;
case 2:
echo NULL;
break;
}
echo "</td>";
echo "<td><a href='update.php?ID=".$result[id_candidat]."'>".substr($result[rezum_txt],0,200)."</a></td>";
echo "<td>".$result[id_city]."</td>";
echo "<td>";
$veb = "<a href=".$result[veb]." target=".$result[veb]." > veb </a>";
switch($result['veb'] or NULL)
{
case 1:
echo $veb;
break;
case 2:
echo NULL;
break;
}
echo "</td>";
//echo '<td><input type="checkbox" name="item[]" value="'.$result[id_candidat].'" /></td>';
echo "<td><input type='checkbox' name='item[]' value=".$result[id_candidat]."></td>";
//echo "<td><a href='delet.php?del=".$result[id_candidat]."'>Удалить</a></td>";
echo "<td>".substr($result[data],2,9)."</td>";
echo "<td><a href='file/". $result[file]."'>" .substr($result['file'],0,10 ). "</a></td>
</tr>";
}
echo "</table><br>";
echo '</form>';
$q="SELECT count(*) FROM `kandidat`";
$res=mysql_query($q);
$row=mysql_fetch_row($res);
$total_rows=$row[0];
$num_pages=ceil($total_rows/$per_page);
for($i=1;$i<=$num_pages;$i++) {
if ($i-1 == $page) {
echo $i." ";
} else {
echo '<b><font size="5" face="Arial"><a href="'.$_SERVER['PHP_SELF'].'?page='.$i.'">'.$i.'</a></font></b> ';
}
}
?>
|
|