From 9847c616a2ccc60ace80e8fbfafbc99673b09a43 Mon Sep 17 00:00:00 2001
From: root
Date: Sun, 23 Feb 2014 18:36:06 +0100
Subject: minor

---
 www/select.php | 22 +++++++++++++---------
 1 file changed, 13 insertions(+), 9 deletions(-)

(limited to 'www/select.php')

diff --git a/www/select.php b/www/select.php
index 1dda9cf..78ab1bc 100644
--- a/www/select.php
+++ b/www/select.php
@@ -3,18 +3,22 @@
 //session_start();
 
 $db = new SQLite3("../database/sqlite.db");
-$user=2;
-$parent=1;
+$owner=2;
+$parentdir=0;
+$count=0;
 $result_db = $db->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();		
+while($result[$count]=$result_db->fetchArray(SQLITE3_NUM)){
+	while(!empty($result)){
+		$dimension = count($result);
+		for($i=0;$i<$dimension;$i++){
+			echo "result: " . $result[$i][2] . " dimension: " . $dimension . " ";
+			$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[$count]=$result_db->fetchArray();
+		}
 	}
+			$count++;
 }
 
 /*
-- 
cgit v1.2.3