CREATE TABLE IF NOT EXISTS `category` (
`sid` int(2) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`parent_id` int(2) DEFAULT '0',
`level` int(1) NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
INSERT INTO `category` (`sid`, `name`, `parent_id`, `level`) VALUES
(1, 'Общая категория', 0, 0),
(2, 'Парикмахерская', 1, 1),
(3, 'Бассейн', 1, 1),
(4, 'Массаж', 1, 1),
(5, 'Плавание', 3, 2),
(6, 'Аквааэробика', 3, 2);
<? $service_query="SELECT * FROM category ORDER By level, sid ASC";
$service_query=mysqli_query($connector, $service_query);
$service_row = mysqli_fetch_row($service_query);
$current_level = 0;
$level_shift=0;
while($service_data=mysqli_fetch_assoc($service_query)){
if($service_data["level"]==$current_level) {
$level_shift++;?>
<div style="position: absolute; top: <?php echo 50+$service_data['level']*200;?>px; left: <?php echo 0+200*$level_shift; ?>px">
<?php echo $service_data["name"];?></div>
<?php }
else {$level_shift=0;?>
<div style="position: absolute; top: <? echo 50+$service_data['level']*200;?>px; left: <?php $level_shift=0; echo "0";?>px"><?php echo $service_data["name"];?></div>
<?$current_level++;
} }?>