Improve account name
authorJoey Schulze <joey@infodrom.org>
Thu, 3 Apr 2014 21:12:21 +0000 (21:12 +0000)
committerJoey Schulze <joey@infodrom.org>
Thu, 3 Apr 2014 21:12:21 +0000 (21:12 +0000)
src/InfoCon/account/edit.wml

index 1fad265..c4d72c3 100644 (file)
@@ -20,7 +20,7 @@
     pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");
 
     $query = "SELECT $table.blz_kto,datum,category,descr,from_to,statement,$value,name "
-           ."FROM $table,account_names "
+            ."FROM $table JOIN account_names using(blz_kto) "
            ."WHERE $table.id = $_GET[id]";
     $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");