function getContent($pid=0, $level=0){ $query = mysql_query("SELECT id, pid, title FROM content WHERE pid = '$pid'"); while ($sql = mysql_fetch_array($query)){ echo str_repeat(" " , $level); echo $level." - ".$sql['title']."<br />"; getContent($sql['id'], $level++); } }getContent();