MYSQL ausgabe

<?php
// Verbindung zum Datenbankserver
	$db=mysql_connect("$servername", "$username", "$password") or die (mysql_error ());  
	if ($db==false) { echo "Keine Verbindung möglich!"; exit; }   

// Datenbank auswählen
	mysql_select_db("$dbname") or die(mysql_error());   

// SQL-Query
	//$strSQL = "SELECT * FROM menu WHERE group_id = '1' "; 
	$strSQL = "SELECT Master.* FROM menu as Master JOIN menu as Slave ON Slave.parent_id = Master.id ORDER BY Master.id";  

// Query ausführen (die Datensatzgruppe $rs enthält das Ergebnis)
	$rs = mysql_query("$strSQL ")or die ("Fehlermeldung = ". mysql_error());  

// Schließt die Datenbankverbindung
	mysql_close();


echo '<select class="form-control">';  
			while ($row = mysql_fetch_assoc($rs)) {
    			if ($row['parent_id'] == 0){  
       				echo '<option>'.$row['title'].'</option>';  
    			} else 
       				echo '<option>--- '.$row['title'].'</option>';  
    			}
		echo '</select>';  
?>

echo '<select class="form-control">';  
		while ($row = mysql_fetch_assoc($rs)) 
		{
    		if ($row['parent_id'] == 0)  
		{	echo '<option>'.$row['title'].'</option>'; 	}   
		else 
       		echo '<option> --- '.$row['title'].'</option>';  
    		}
		echo '</select>';  

/* execute statement */
    $rs->execute();

    /* bind result variables */
    $rs->bind_result($master, $slave);

    /* fetch values */
    while ($rs->fetch()) {
        printf ("%s (%s)\n", $master, $slave);  
    }

    /* close statement */
    $stmt->close();

 
<?php
// Verbindung zum Datenbankserver
	$db=mysql_connect("$servername", "$username", "$password") or die (mysql_error ());  
	if ($db==false) { echo "Keine Verbindung möglich!"; exit; }   

// Datenbank auswählen
	mysql_select_db("$dbname") or die(mysql_error());   

// SQL-Query
	$strSQL= " select -- id, case when parent_id=0 then title else '--- ' ||title  end  as title from menu where group_id = 1 order by case when parent_id = 0 then id *1000 else parent_id*1000 + id end";  

// Query ausführen (die Datensatzgruppe $rs enthält das Ergebnis)
	$rs = mysql_query("$strSQL ")or die ("Fehlermeldung = ". mysql_error());  

// Schließt die Datenbankverbindung
	mysql_close();
?>

 
$strSQL= " select  case when parent_id=0 then title else '--- ' ||title  end  as title  from menu where group_id = 1 order by case when parent_id = 0 then id *1000 else parent_id*1000 + id end";  

echo '<select class="form-control">';    
                  while ($row = mysql_fetch_assoc($rs))  { echo '<option>'.$row['title'].'</option>' ;}   
echo '</select>';  

 
<?php
echo '<div class="panel-group archiv" id="accordion" role="tablist" aria-multiselectable="true" >';    
           while ($row = mysql_fetch_assoc($rs))  
	{ 
				  
			  
echo '  <div class="panel panel-default">';   
echo '  <div class="panel-heading" role="tab" id="'. $row['id'] .'">  
           <h4 class="panel-title">  
           <a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapse'. $row['id'] .'" aria-expanded="false" aria-controls"collapse1"="">  
                   '.$row['title'].'  
             </a>
             </h4>
             </div>';  

echo '	<div style="height: 0px;" aria-expanded="false" id="collapse'. $row['id'] .'" class="panel-collapse collapse" role="tabpanel" aria-labelledby="'. $row['id'] .'">  
              	<div class="panel-body">  
                 <ul> ';  // wenn untermenüs zum hauptmenü vorhanden sind  
		 echo '<li> <a href=index.php?page=archiv&content=4&cat='.$row['title'].'> <i class="fa fa-caret-right"></i>&nbsp;'.$row['title'].'</a>  </li>  
		</ul> 
              	</div>
            	</div>';  
			
echo '</div> '; 			    
?>