Категории разделов

CREATE TABLE `catalogue` (
`id` INT UNSIGNED AUTO_INCREMENT, 
`title` VARCHAR (50), 
`pid` INT UNSIGNED, 
PRIMARY KEY (`id`)
)
 
CREATE TABLE `adverts` (
`id` int(20) NOT NULL auto_increment,
`category_id` int(11) NOT NULL default '0',
 ...
`body` text NULL,
`title` text (150) NULL,
`img_big` longblob NULL,
`img_small` blob NULL,
`mimetype` varchar(16) NULL default `image/*`,
 PRIMARY KEY (`id`)
 FOREIGN KEY ('category_id') REFERENCES 'catalogue' ('id')
  )

function tree($pid, $lvl){
        $query = mysql_query("SELECT * FROM catalogue WHERE pid = '$pid'") or die(mysql_error());
        while($categ = mysql_fetch_object($query)){
     
           for($i=0;$i<$lvl;$i++){
           echo " &nbsp;";
          }
          $lvl++;
          echo $categ->title;
           echo "<br>\n";
           tree($categ->id, $lvl--);
        }
    }
    tree(0, 0); //Вывод скрипта

 $query = mysql_query("SELECT c.title, c.pid, a.id, a.category_id, a.body FROM `adverts` a INNER JOIN `catalogue` c ON c.id=a.category_id ORDER BY category_id DESC");
while($adverts = mysql_fetch_object($query)){
echo "Разделы ".$adverts[title].""; 
echo "Инфо ".$adverts[body]."";}

 echo "<a href='adverts34.php?action=adverts&id=".$categ->id."'>".$categ->title."</a>";

if ( !isset( $_GET["action"] ) ) $_GET["action"] = "adverts"; 
switch ( $_GET["action"] )
{
  case "adverts":    // Вывод всех объявлений
    show_adverts(); break;
  default:
    show_adverts();
}
 
function show_adverts() {
 $query = mysql_query("SELECT c.title, c.pid, a.id, a.category_id, a.body FROM `adverts` a INNER JOIN `catalogue` c ON c.id=a.category_id ORDER BY category_id DESC");
while($adverts = mysql_fetch_object($query)){
echo "Разделы ".$adverts[title].""; 
echo "Инфо ".$adverts[body]."";}
}

$action = isset($_GET['action'])?$_GET['action']:'adverts';
$id = (int)$_GET['id'];
switch ( $action )
{
  case 'adverts':    // Вывод всех объявлений
    show_adverts(); break;
  default:
    show_adverts();
}
 
function show_adverts() {
 $query = mysql_query("SELECT c.title, c.pid, a.id, a.category_id, a.body FROM `adverts` a INNER JOIN `catalogue` c ON c.id=a.category_id WHERE c.id=$id ORDER BY category_id DESC");
while($adverts = mysql_fetch_object($query)){
echo "Разделы ".$adverts[title].""; 
echo "Инфо ".$adverts[body]."";}
}

function block($pid=0) {
$query = mysql_query("SELECT * FROM catalogue WHERE pid='".($pid ? $pid : 0)."' ORDER BY pid DESC");
echo '<ul>';
while($row = mysql_fetch_array($query)) {
echo '<li><a href="adverts.php?action=adverts&id='.$row['id'].'">'.$row['title'];
block($row['id']);
echo "</li>";
}
echo '</ul>';
}
 
block();

$action = isset($_GET['action'])?$_GET['action']:'adverts';
$id = (int)$_GET['id'];
switch ( $action )
{
  case 'adverts':    // Вывод всех объявлений
    show_adverts(); break;
  default:
    show_adverts();
}
 
 
function show_adverts() {
        $query = mysql_query("SELECT c.id, c.title, c.pid, a.id, a.category_id, a.estate, a.room, a.address, a.flor, a.area, a.tel, a.door, a.bal, a.bal3, a.bal4, a.price, a.body, a.title_pic, a.img_big, a.img_small, a.mimetype FROM `adverts` a INNER JOIN `catalogue` c ON c.id=a.category_id WHERE c.id=$id ORDER BY category_id DESC");
while($adverts = mysql_fetch_object($query)){
 
 echo $adverts['title']; //это вывод заголовка
            // Выводим в таблице
  echo '<table width="564" height="270"  border="0px double #000" class="advor">' ;
  echo ' <tr>';
  echo '<td width="73">Раздел</td>';
  echo '<td width="179">Тип недвижимости</td>';
  echo '<td width="147">Описание</td>';
  echo ' <td width="137">Редактирование</td>';
  // Выводим раздел
  $number1 = mysql_num_rows($adverts['category_id']);
  echo '<td width="73"><p>'.$adverts['category_id'].'</p>['.$number1.']';
  echo ' </td>';
  //Выводим тип недвижимости
  echo ' <td width="179"> '.$adverts['estate'].'' ;
  echo ' </td>';
  echo '<td width="147">';
  // Выводим изображение
  $title = str_replace( '"', '', $adverts['title_pic'] );
  echo '<div><a href="newsimage.php?size=big&id='.$adverts['id'].'" target="_blank">';
  echo '<img src="newsimage.php?size=small&id='.$adverts['id'].'" alt="'.$title.'" border="0" /></a></div>'; 
  // Разделительная линия между отдельными изображениями
  echo '<hr>';
  // Выводим описание (все функции)
  echo ''.$adverts['room'].''.$adverts['address'].''.$adverts['flor'].''.$adverts['area'].''.$adverts['tel'].''.$adverts['door'].''.$adverts['bal'].''.$adverts['bal3'].''.$adverts['bal4'].''.$adverts['price'].''.$adverts['body'].'' ;
  echo '</td>';
  //Функция удаления
  echo '<td width="137"><a href="advertslist.php?action=delete"><p>Удалить</p></a>
    <a href="advertslist.php?action=editform"><p>Изменить</p></a>';
 echo '</td></tr></table>';
 // Всего объявлений
 $number0 = mysql_num_rows($adverts['id']);
 echo ' Всего объявлений '.$number0.'';
 
         }
 }

 $query = mysql_query("SELECT c.id, c.title, c.pid, a.id, a.category_id, a.estate, a.room, a.address, a.flor, a.area, a.tel, a.door, a.bal, a.bal3, a.bal4, a.price, a.body, a.title_pic, a.img_big, a.img_small, a.mimetype FROM `adverts` a INNER JOIN `catalogue` c ON c.id=a.category_id WHERE c.id=$id ORDER BY category_id DESC");
while($adverts = mysql_fetch_object($query)){