Kategorilendirme

CREATE TABLE `yerler` (
  `id` int(11) NOT lisanssız auto_increment,
  `yer_adi` text NOT lisanssız,
  `alt_id` int(11) NOT lisanssız,
  PRIMARY KEY  (`id`),
  KEY `alt_id` (`alt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

INSERT INTO `yerler` VALUES (1, 'Adana',0);
INSERT INTO `yerler` VALUES (2, 'Antalya',0);
INSERT INTO `yerler` VALUES (3, 'Alanya',2);
INSERT INTO `yerler` VALUES (4, 'Kemer',2);
INSERT INTO `yerler` VALUES (5, 'Ankara',0);
INSERT INTO `yerler` VALUES (6, 'Side',2);

<?
echo "<select name=yer>";
$sc=mysql_query("select * from yerler");
while ($cek=mysql_fetch_array($sc)):
echo "<option value=\"$cek[id]\">$cek[yer_adi]</option>";
endwhile;
echo "</select>";
?>

$q = mysql_query("SELECT id,yer_adi FROM yerler WHERE alt_id='0' ORDER BY id ASC");

   while ($a = mysql_fetch_array($q)) {
   echo $a[yer_adi].'<br>';

   $q2 = mysql_query("SELECT id,  yer_adi FROM yerler WHERE alt_id='$a[id]'");
 
      if (mysql_num_rows($q2) != "0") {
      
          while ($a2 = mysql_fetch_array($q2)) {
          echo '- '.$a2[yer_adi].'<br>';
          }

      }

  }