From 8b23807a0d23eb87384f8d4df519f654254cbf0e Mon Sep 17 00:00:00 2001
From: root
Date: Fri, 28 Feb 2014 15:08:45 +0100
Subject: .

---
 www/select.php | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'www')

diff --git a/www/select.php b/www/select.php
index f0cd143..d1b6189 100644
--- a/www/select.php
+++ b/www/select.php
@@ -6,14 +6,22 @@ $db = new SQLite3("../database/sqlite.db");
 $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';");
+$result_db = $db->query("SELECT id, parent, name, share FROM files WHERE owner=$owner AND folder='DIRECTORY' AND share='PUBLIC';");
 
 while($result[$count] = $result_db->fetchArray(SQLITE3_NUM)){
 	$count++;
 }
 
+echo "Found " . $count . " folder. <br>";
+
 for($i=0;$i<$count;$i++){
-	echo count($result);
+
+	echo "name: " . $result[$i][2] . "<br>";
+/*
+	for($j=0;$j < count($result[$i]); $j++){
+		echo "name: " . $result[$i][$j] . "<br>";
+	}
+*/
 }
 
 /*
-- 
cgit v1.2.3