вот код страницы
<?php include ("blocks/db.php");?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title>Удаление фильма</title>
</head>
<body>
<h2>Удалить фильм?</h2>
<?php
if (isset($_GET['id']))
{
$id=$_GET['id'];
}
else
if (isset($_POST['id']) and isset($_POST['submit']) and $_POST['confirm'] == 'yes')
{
$query = 'DELETE FROM films WHERE id ='.$id.'LIMIT 1';
$result = mysql_query($query);
$query = 'DELETE FROM kinoteatrs WHERE id_f ='.$id.'LIMIT 1';
$result2 = @mysql_query($query);
exit ('Фильм удален');
}
else
{
echo 'Фильм не удален';
}
$query = 'SELECT * FROM films WHERE id ='.$id;
$result = mysql_query($query);
$myrow2012 = mysql_fetch_array($result);
?>
<table id='bootom_border' style=' margin:0 0 0 20px;' width='950px' align='left' cellpadding='1' cellspacing='20px' border = '0'>
<tr>
<td> <strong> <? echo $myrow2012['title_f'] ?> </strong></td>
<td></td>
<tr>
<td> <a name='<? echo $myrow2012['id'] ?>'> <img src='<?php echo '../'.$myrow2012['img']?>' width='273' height='400' /></a></td>
<td align='center' valign='top' >
<?php echo $myrow2012['video']?>
</td>
</tr>
<tr>
<td valign='top' >
<table>
<tr>
<td><?php
/* вывод кинотеатров из второй таблицы для фильма */
$query = 'SELECT * FROM kinoteatrs WHERE id_f = '.$myrow2012['id'];
echo $query;
$result = mysql_query($query);
while ($row = mysql_fetch_array ($result))
{
echo '<p><strong>Кинотеатр:</strong> '.$row['title_kinoteatra'].'<br />';
echo'<strong>Дата:</strong> '.$row['data_seansa']. '<br />';
echo '<strong>Время:</strong> '.$row['time_seansa'].'</p>';
};
?> </td>
</tr>
</table>
</td>
<td valign='top'>
<div style='background-image:url(../img/descr_img/fon_03.gif); background-repeat:repeat-y'><img src='../img/descr_img/fon_01.gif' />
<div style='padding-left:20px;padding-right:15px;'> <?php echo $myrow2012['description']?> </div>
<img src='../img/descr_img/fon_05.gif' /> </div>
</td>
</tr>
<tr>
<td>
</td>
<td> </td>
</tr>
</table>
<form action="godelfims.php" method="post">
<input name="confirm" type="radio" value="yes" />Да
<input name="confirm" type="radio" value="no" />Нет
<input name="id" type="hidden" value="<?php echo $myrow2012['id']; ?>" />
<input name="submit" type="button" value=" Удалить" />
</form>
<a href="index.php"><<< Страница Администратора</a>
</body>
</html>