Use an alias for max(id) fetch

1 files changed, 2 insertions, 2 deletions

diff --git a/db/citymapper.php b/db/citymapper.php
index a839316..3147c82 100644
--- a/db/citymapper.php
+++ b/db/citymapper.php
@@ -56,13 +56,13 @@ class CityMapper extends Mapper {
 		$query->execute(array($userId, $name));
 		\OCP\DB::commit();
 
-		$sql = 'SELECT max(id) FROM ' .
+		$sql = 'SELECT max(id) as maxid FROM ' .
 			'*PREFIX*weather_city WHERE user_id = ? and name = ?';
 		$query = \OCP\DB::prepare($sql);
 		$result = $query->execute(array($userId, $name));
 
 		if ($row = $result->fetchRow()) {
-			return $row['max'];
+			return $row['maxid'];
 		}
 		return null;
 	}