From ce4fa77b60ed3aad6dcd09dbd48fd7b119bc1261 Mon Sep 17 00:00:00 2001
From: Benjamin Franzke <benjaminfranzke@googlemail.com>
Date: Wed, 21 Nov 2012 12:04:06 +0100
Subject: sqlbox: Show query field names

---
 sqlbox/view.php | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'sqlbox')

diff --git a/sqlbox/view.php b/sqlbox/view.php
index 8cf6848..dd20fb9 100644
--- a/sqlbox/view.php
+++ b/sqlbox/view.php
@@ -89,6 +89,10 @@ if (isset($data->query)) {
 		error("Query failed!");
 
 	echo "<table border=\"1\">";
+	$n = pg_num_fields($result);
+	for ($i = 0; $i < $n; $i++) {
+		echo "<th>".pg_field_name($result, $i)."</th>";
+	}
 	while($row=pg_fetch_row($result)){
 		echo "<tr>";
 		foreach($row as $val) {
-- 
cgit