| Код |
--
-- Структура таблицы `qqq`
--
CREATE TABLE `qqq` (
`id` int(11) NOT NULL auto_increment,
`q1` varchar(5) NOT NULL default '',
`q2` tinyint(4) NOT NULL default '0',
`wai05-1` varchar(50) NOT NULL default '',
`wai05-2` varchar(50) NOT NULL default '',
`wai06` varchar(50) NOT NULL default '',
`waf05` varchar(50) NOT NULL default '',
`waf06` varchar(50) NOT NULL default '',
`ta05` varchar(50) NOT NULL default '',
`ta06` varchar(50) NOT NULL default '',
`zeit` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=41 ;
--
-- Дамп данных таблицы `qqq`
--
INSERT INTO `qqq` VALUES (9, 'Di', 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.00-8.45');
INSERT INTO `qqq` VALUES (10, 'Di', 2, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.45-9.30');
INSERT INTO `qqq` VALUES (11, 'Di', 3, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '9.45-10.30');
INSERT INTO `qqq` VALUES (12, 'Di', 4, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '10.30-11.15');
INSERT INTO `qqq` VALUES (13, 'Di', 5, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '11.30-12.15');
INSERT INTO `qqq` VALUES (14, 'Di', 6, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '12.15-13.00');
INSERT INTO `qqq` VALUES (15, 'Di', 7, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '13.30-14.15');
INSERT INTO `qqq` VALUES (16, 'Di', 8, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '14.15-15.00');
INSERT INTO `qqq` VALUES (25, 'DO', 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.00-8.45');
INSERT INTO `qqq` VALUES (26, 'DO', 2, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.45-9.30');
INSERT INTO `qqq` VALUES (27, 'DO', 3, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '9.45-10.30');
INSERT INTO `qqq` VALUES (28, 'DO', 4, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '10.30-11.15');
INSERT INTO `qqq` VALUES (29, 'DO', 5, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '11.30-12.15');
INSERT INTO `qqq` VALUES (30, 'DO', 6, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '12.15-13.00');
INSERT INTO `qqq` VALUES (31, 'DO', 7, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '13.30-14.15');
INSERT INTO `qqq` VALUES (32, 'DO', 8, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '14.15-15.00');
INSERT INTO `qqq` VALUES (33, 'Fr', 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.00-8.45');
INSERT INTO `qqq` VALUES (34, 'Fr', 2, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.45-9.30');
INSERT INTO `qqq` VALUES (35, 'Fr', 3, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '9.45-10.30');
INSERT INTO `qqq` VALUES (36, 'Fr', 4, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '10.30-11.15');
INSERT INTO `qqq` VALUES (37, 'Fr', 5, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '11.30-12.15');
INSERT INTO `qqq` VALUES (38, 'Fr', 6, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '12.15-13.00');
INSERT INTO `qqq` VALUES (39, 'Fr', 7, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '13.30-14.15');
INSERT INTO `qqq` VALUES (40, 'Fr', 8, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '14.15-15.00');
INSERT INTO `qqq` VALUES (17, 'Mi', 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.00-8.45');
INSERT INTO `qqq` VALUES (18, 'Mi', 2, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.45-9.30');
INSERT INTO `qqq` VALUES (19, 'Mi', 3, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '9.45-10.30');
INSERT INTO `qqq` VALUES (20, 'Mi', 4, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '10.30-11.15');
INSERT INTO `qqq` VALUES (21, 'Mi', 5, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '11.30-12.15');
INSERT INTO `qqq` VALUES (22, 'Mi', 6, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '12.15-13.00');
INSERT INTO `qqq` VALUES (23, 'Mi', 7, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '13.30-14.15');
INSERT INTO `qqq` VALUES (24, 'Mi', 8, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '14.15-15.00');
INSERT INTO `qqq` VALUES (1, 'MO', 1, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.00-8.45');
INSERT INTO `qqq` VALUES (2, 'MO', 2, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '8.45-9.30');
INSERT INTO `qqq` VALUES (3, 'MO', 3, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '9.45-10.30');
INSERT INTO `qqq` VALUES (4, 'MO', 4, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '10.30-11.15');
INSERT INTO `qqq` VALUES (5, 'MO', 5, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '11.30-12.15');
INSERT INTO `qqq` VALUES (6, 'MO', 6, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '12.15-13.00');
INSERT INTO `qqq` VALUES (7, 'MO', 7, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '13.30-14.15');
INSERT INTO `qqq` VALUES (8, 'MO', 8, ' ', ' ', ' ', ' ', ' ', ' ', ' ', '14.15-15.00');
|
| Код |
<html>
<head>
<title></title>
</head>
<body>
<?php
mysql_connect('localhost', 'root', '') or die("Ошибка соединения");
mysql_query("SET NAMES cp1251;");
mysql_select_db('test');
$z = 'SELECT * FROM `qqq` ORDER BY `q1`, `q2`';
$r = mysql_query($z);
$a = '<table border="1">';
$a .= '<tr>';
$a .= '<td>q1';
$a .= '<td>q2';
$a .= '<td>wai05-1';
$a .= '<td>wai05-2';
$a .= '<td>wai06';
$a .= '<td>waf05';
$a .= '<td>waf06';
$a .= '<td>ta05';
$a .= '<td>ta06';
$a .= '<td>zeit';
for($i=0; $i<mysql_num_rows($r); $i++){
$f = mysql_fetch_array($r);
$a .= '<tr>';
$a .= '<td>'.$f['q1'];
$a .= '<td>'.$f['q2'];
$a .= '<td>'.$f['wai05-1'];
$a .= '<td>'.$f['wai05-2'];
$a .= '<td>'.$f['wai06'];
$a .= '<td>'.$f['waf05'];
$a .= '<td>'.$f['waf06'];
$a .= '<td>'.$f['ta05'];
$a .= '<td>'.$f['ta06'];
$a .= '<td>'.$f['zeit'];
}
$a .= '</table>';
echo $a;
?>
</body>
</html>
|
|
