query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';");
while(!empty($result=$result_db->fetchArray())){
$dimension = count($result);
for($i=0;$i<$dimension;$i++){
echo $result[$i][2];
$parentdir=$result[$i][0];
$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';");
$result=$result_db->fetchArray();
}
}
/*
function select_db ($db, $owner, $parentdir){
$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE parent=$parentdir AND owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';");
$count=0;
while ($result = $result_db->fetchArray()){
$array[$count]=$result; /*2D Array, an Stelle $count ist das $result Array mit Ergebnissen des SELECTs abgelegt*/
/* $count++;
}
return $array;
}
$row = select_db($db, $user, $parent);
$dimension = count($row);
echo "dimension: " . $dimension . "
";
for($i=0;$i<$dimension;$i++){
echo "length [$i]: " . count($row[$i]) . "
";
for($j=0;$j<4;$j++){
print_r($row[$i][$j]);
echo "
";
}
}
*/