<?
$form = 0;
- $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 ORDER BY date,nr";
+ $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 AND visible=1 ORDER BY date,nr";
$sth = pg_exec ($dbh, $query);
if (pg_NumRows ($sth) > 0) {
printf (" %d. %s %s (%.2f DM)<br>", $row['nr'], $date, $row['description'], $row['price']);
}
- $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 ORDER BY date,nr";
+ $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 AND visible=1 ORDER BY date,nr";
$sth = pg_exec ($dbh, $query);
if (!form && pg_NumRows ($sth) > 0) {