--
-- Структура таблицы `stud`
--
CREATE TABLE IF NOT EXISTS `stud` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`famli` text NOT NULL,
`imia` text NOT NULL,
`oche` text NOT NULL,
`dr` date NOT NULL,
`inn` int(23) NOT NULL,
`mesroj` text NOT NULL,
`mesjit` text NOT NULL,
`gtoup` text NOT NULL,
`spec` text NOT NULL,
`kval` varchar(255) NOT NULL,
`datapost` date NOT NULL,
`prikaznom` int(23) NOT NULL,
`tele` text NOT NULL,
PRIMARY KEY (`id`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
<?php
include ("blocks/bd.php");
if (isset($_POST['famli'])) {$famli = $_POST['famli']; }
if (isset($_POST['imia'])) {$imia = $_POST['imia']; }
if (isset($_POST['oche'])) {$oche = $_POST['oche']; }
if (isset($_POST['dr'])) {$dr = $_POST['dr']; }
if (isset($_POST['inn'])) {$inn = $_POST['inn']; }
if (isset($_POST['mesroj'])) {$mesroj = $_POST['mesroj']; }
if (isset($_POST['kols'])) {$kols = $_POST['kols']; }
?>
<!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><?php echo $myrow['title'] ?></title>
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="1500" border="0" align="center" cellpadding="0" cellspacing="0" class="main_border">
<!--подключаем шапку сайта-->
<? include("blocks/header.php"); ?>
<tr>
<td><table width="1500" border="0" cellspacing="0" cellpadding="0">
<tr>
<!--Левый блок -->
<? include("blocks/lefttd.php"); ?>
<td valign="top" bgcolor="#FFFFFF">
<br>
<select name=$kols size=1 class=select>
<option value=<?=$myrow['famli']?> >Фамилия</option>
<option value=<?=$myrow['imia']?> >Имя</option>
<option value=<?=$myrow['oche']?> >очество</option>
<option value=<?=$myrow['dr']?> >дата рождения</option>
<option value=<?=$myrow['inn']?> >ИНН</option>
</select>
<input type=submit name=go value=OK class=ok>
<?php
$result = mysql_query("SELECT * FROM stud ORDER BY ".$_POST['kols']."",$db);
$myrow = mysql_fetch_array($result);
do {
printf (" <table align='center' class='lesson'>
<tbody>
<tr>
<td><p>%s</p></td>
<td><p class='lessons'>%s</p></td>
<td><p>%s</p></td>
<td><p>%s</p></td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
<td><p>%s</p> </td>
</tr>
</tbody>
</table>",$myrow["famli"],$myrow["imia"],$myrow["oche"],$myrow["dr"],$myrow["inn"],$myrow["mesroj"],$myrow["mesjit"],$myrow["gtoup"],$myrow["spec"],$myrow["kval"],$myrow["datapost"],$myrow["prikaznom"],$myrow["tele"]);
}
while ($myrow = mysql_fetch_array($result));
?>
</td>
</tr>
</table></td>
</tr>
<!--нижни элемент-->
<?php include("blocks/footer.php"); ?>
</table>
</body>
</html>
помогите сортировку сделать?
Главная
Помощь
Поиск
Пользователи
Форумы портала PHP.SU » PHP » Программирование на PHP » Работа с СУБД (Модераторы: OrmaJever, Саныч)
Описание: сортировка не удается
