From 6c7a5ff06159c6908a47f11adbe30e2349a5fd75 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 12 Jun 2018 17:13:37 +0200
Subject: [inc/Database] Method to return single-column queries as array

---
 inc/database.inc.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/inc/database.inc.php b/inc/database.inc.php
index d5992795..3b2414b5 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -76,6 +76,19 @@ class Database
 		return $res->fetchAll(PDO::FETCH_ASSOC);
 	}
 
+	/**
+	 * Fetch the first column of the query as a plain list-of-values array.
+	 *
+	 * @return array|bool List of values representing first column of query
+	 */
+	public static function queryColumnArray($query, $args = array(), $ignoreError = null)
+	{
+		$res = self::simpleQuery($query, $args, $ignoreError);
+		if ($res === false)
+			return false;
+		return $res->fetchAll(PDO::FETCH_COLUMN, 0);
+	}
+
 	/**
 	 * Execute the given query and return the number of rows affected.
 	 * Mostly useful for UPDATEs or INSERTs
-- 
cgit v1.2.3-55-g7522