<html>
<head>
<meta http-equiv="Content-Type"Content=<"text/html;charsert=windows-1251"/>
<Title>Стоимость занятий</Title>
</head>
<Body>
<Center>
<H1>Стоимость занятий</H1>
</Center>
<a href="http://localhost/main/">Назад</a>
<?php
$db=new mysqli('localhost','root','','detskui sad')or die($db->error);
if ($_SERVER['REQUEST_METHOD']=='POST') {
$name = ($_POST['name band']);
$teachers =($_POST['teachers']);
$classes_id =($_POST['classes_id']);
$area = ($_POST['area']);
$price_per _lesson = ($_POST['price_ per_ lesson']);
$cost = ($_POST['cost']);
$number_ of_ hours = ($_POST['number_ of_ hours']);
if ($_POST['id']) {
$query=" UPDATE `classes`
SET `name`='$name', `prole`='$teachers',`band_id`='$band_id',
`area`='$area',`price_per _lesson`='$price per lesson',`cost`='$cost',"
. "`number_of_hours`='$number of hours'
WHERE id=$id";
} else {
$query="
INSERT INTO `classes`
SET `name`='$name', `teachers`='$teachers',`classes_id`='$classes_id',
`area`='$area',`price_per_lesson`='$price per lesson',`cost`='$cost',"
. "`number_of_hours`='$number of hours'";
}
$result= $db->query($query) or die($db->error);
header("location:http://localhost/main/classes.php");
};
if (isset($_GET['id'])) {
$id =$_GET['id'];
$query = " SELECT *
FROM `classes`
WHERE `id`=$id";
$result = $db->query($query) or die ($db->error);
$row=$result->fetch_array();
} else {
$row['name']="";
$row['teachers']="";
$row['classes_id']="";
$row['area']="";
$row['rent']="";
$row['price per lesson']="";
$row['number of hours']="";
$row['id']=0;
}
$query2="SELECT * from `classes`";
$result2 = $db->query($query2) or die ($db->error);
?>
<form method="POST">
<label>Название группы</label><br />
<input type="text" name="name" value="<?=$row['name']?>"><br />
<label>Преподаватель</label><br />
<input type="text" name="teachers" value="<?=$row['teachers']?>"><br />
<label>Группа</label><br />
<select name="name_id">
<?php
While($row2=$result2->fetch_array()) {
$name_id =$row2['id'];
$band_name = $row2['name'];
echo "<option Value=\"".$band_id."\">".$band_name."</option>";
}
?>
</select><br/>
<label>Район проживания</label><br/>
<input type="text" name="area" value="<?=$row['area']?>"><br/>
<label>Цена занятия</label><br/>
<input type="text" name="price per lesson" value="<?=$row['price per lesson']?>">
<br/>
<label>Стоимость</label><br/>
<input type="text" name="cost" value="<?=$row['cost']?>"><br />
<label>Кол-во часов<label><br/>
<input type="text" name="number of hours" value="<?=$row['number of hours']?>">
<br/>
<input type="hidden" name="id" value="<?=$row['id']?>">
<input type="submit"><br />
</form>
</body>
</html>
Все равно ошибку высвечивает