From a4d8c7f7b7670dd7ac2a8c09441b522ea4fa11a4 Mon Sep 17 00:00:00 2001
From: Jan Klemkow <j.klemkow@wemelug.de>
Date: Wed, 21 Nov 2012 11:58:37 +0100
Subject: Query output format as table.

---
 sqlbox/view.php | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

(limited to 'sqlbox')

diff --git a/sqlbox/view.php b/sqlbox/view.php
index e9e4ba6..c6f99a1 100644
--- a/sqlbox/view.php
+++ b/sqlbox/view.php
@@ -88,10 +88,15 @@ if (isset($data->query)) {
 	if (!$result)
 		error("Query failed!");
 
+	echo "<table>";
 	while($row=pg_fetch_row($result)){
-		print_r($row);
-		echo "<br />\n";
+		echo "<tr>";
+		foreach($row as $val) {
+			echo "<td>$val</tr>";
+		}
+		echo "</tr>";
 	}
+	echo "</table>";
 }
 
 // Finish the page
-- 
cgit