#include <infocon.style>
+<future>
<page func=InfoCon title="Kontoführung">
<blockquote>
<input type=hidden name=formtype value=admin>
<?
- $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
- or die("Unable to connect to SQL server");
-
$query = "SELECT blz_kto,name,display,date_part('year',min(datum)) AS year_from,date_part('year', max(datum)) AS year_to " .
"FROM account_names JOIN account using(blz_kto) " .
"GROUP BY blz_kto,name,display ORDER BY name";
- $sth = pg_exec ($dbh, $query);
-
- for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
- $row = pg_fetch_array ($sth, $nr);
+ foreach ($db->fetchAssocList($query) as $row) {
$both = explode (":", $row['blz_kto']);
printf ("<br><input type=\"checkbox\" name=\"display_%s\" value=\"1\"%s> ".
"<input type=\"text\" name=\"name_%s\" value=\"%s\" size=\"30\"> ".