CREATE TABLE classes (
id int(11) NOT NULL,
activity title varchar(25) CHARACTER SET utf32 NOT NULL,
teachers varchar(25) CHARACTER SET utf32 NOT NULL,
band_id int(11) NOT NULL,
area varchar(25) CHARACTER SET utf32 NOT NULL,
price per lesson int(11) NOT NULL,
cost int(11) NOT NULL,
number of hours int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Сам скрипт полностью.
<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>
<H2>Список детей</H2>
<?php
// echo gethostname();
$db=new mysqli('localhost','root','','detskui sad') or die ($db->error);
$query="
SELECT
`baby`.`surname`,`baby`.`firstname`,`baby`.`phone number',
`classes`.`name of the class`,`classes`.`price per lesson`,`classes`.`cost`,[/color]
`garden`.`date p`,`garden`.`date c`,`garden`.`transfer garten`
FROM `baby`,`classes`,`garden`
WHERE `baby`.`id`=`garden`.`bady_id`
AND `classes`.`id`=`garden`.`bahd_id`;
";
$result= $db->query($query) or die($db->error);
echo"<Table><thead><tr>
<th>Фамилия</th>
<th>Имя</th>
<th>Телефон</th>
<th>Название занятия</th>
<th>Цена за занятие</th>
<th>Стоимость</th>
<th>Дата поступления</th>
<th>Дата зачисления</th>
<th>Перевод в другой сад</th
<th></th></tr>
</thead><tbody>";
while($row=$result->fetch_array()){
$lost="";if($row['lost']==1) $lost="переведен";
echo "<tr><td>". $row['surname']."</td> ";
echo "<td>". $row['firstname']."</td>";
echo "<td>".$row['phone number']."</td>";
echo "<td>". $row['name of the class']."</td>";
echo "<td>". $row['price per lesson']."</td>";
echo "<td>". $row['cost']."</td>";
echo "<td>". $row['data p']."</td>";
echo "<td>". $row['data c']."</td>";
echo "<td>". $lost."</td></tr>";
};
echo "</tbody></table>";
?>
</body>
</html>