hehe faktisk fandt jeg lige en måde at vise det som du skrev:
<?php
$con = mysql_connect( "localhost", "brugernavn", "password" );
mysql_select_db( "database", $con );
$results = array();
function getStruct( $parent, $indent = 0 )
{
global $results;
$sql = "
SELECT
page_id
,page_name
FROM
page
WHERE
parent_id = $parent
";
$res = mysql_query( $sql );
if ( mysql_num_rows( $res ) > 0 )
{
while ( $row = mysql_fetch_assoc( $res ) )
{
$results[] = array(
"page_name" => $row['page_name']
,"page_id" => $row['page_id']
,"parent_id" => $parent
,"indent" => $indent
);
getStruct( $row['page_id'], $indent + 1 );
}
mysql_free_result( $res );
}
}
getStruct( 0 );
$n = count( $results );
echo "<table><tr>";
for ( $i = 0; $i < $n; $i++ )
{
$row = $results[ $i ];
if ( $row['parent_id'] == 0 )
{
if ( $i != 0 )
{
echo "</td>";
}
echo "<td valign='top'>";
}
echo str_repeat( " ", $row['indent'] );
echo "$row[page_name]<br>";
}
echo "</tr></table>";
?>
Hvis du vil have det som jeg skrev, så udskift den nederste del af koden med:
foreach ( $results as $row )
{
echo str_repeat( " ", $row['indent'] );
echo "$row[page_name]<br>";
}
