"on line 36" - это 36-ая линия ?
_____________
Обучаю веб-программированию качественно и не дорого: http://school-php.com
Фрилансер, принимаю заказы: PHP, JS, AS (видео-чаты). Писать в ЛС (Личные сообщения на phpforum).
$id_town = $myrow[id_town];
$id_town = $myrow['id_town'];
while ($myrow = mysql_fetch_array($result)) {
<?php include ("blocks/bd.php");
$result = mysql_query("SELECT * from school order by id_town ASC ", $db);
if (!$result)
{
echo "<p>Запрос на выборку данных из базы не прошел.</p>";
exit (mysql_error());
}
if (mysql_num_rows($result) > 0)
{
$myrow = mysql_fetch_array($result);
}
else
{
echo "<p>Информация по запросу не может быть извлечена - в таблице нет записей.</p>";
exit ();
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Школы</title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="60%" border="1" cellspacing="0" cellpadding="4" align="center">
<?php
error_reporting(-1);
while ($myrow = mysql_fetch_array($result)) {
$id_town = $myrow['id_town'];
$result2 = mysql_query("SELECT * FROM school_towns WHERE id_town='" . mysql_real_escape_string($id_town) . "'", $db)
or die(mysql_error());
$myrow2 = mysql_fetch_array($result2);
?>
<tr bgcolor="#FFFF99">
<td align="center"><p class='nomistake'>Название</p></td>
<td align="center"><p class='nomistake'>id_town</p></td>
<td align="center"><p class='nomistake'>Город</p></td>
<td align="center"><p class='nomistake'>Новое id_town</p></td>
</tr>
<tr>
<td><p class='mod'><? printf ("<a href='http://mysite.ru/post.php?id_school=%s' target='_blank'>%s</a>", $myrow["id_school"], $myrow["title"]);?></p></td>
<td><p class='mod'><?=$myrow["id_town"];?></p></td>
<td><p class='mod'><?=$myrow2["title"];?></p></td>
<td><p class='mod'>
<?php
if (isset($_POST['submit'])) {
$id_town = $_POST['id_town'];
$output_form = false;
if (empty($id_town)) {
// we know they are blank
echo "<p><span class='mistake'>Вы забыли заполнить id_town</span></p><br />";
$output_form = true;
}
if (!empty($id_town)) {
$result = mysql_query("UPDATE `school` SET `id_town`=".(int)$id_town);
}
}
else {
$output_form = true;
}
if ($output_form) {
?>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<p><label for="email"><strong>Введите новое id_town:</strong></label>
<input id="id_town" name="id_town" type="text" size="30" value="<?php echo $id_town; ?>" /></p>
<p><input type="submit" name="submit" value="Обновить"></p>
</form>
<?php
}
?>
</p></td>
</tr>
<?php
}
?>
</table>
</body>
</html>