{
global $dbh;
- $query = sprintf ("SELECT COUNT(*) FROM person WHERE project = '%s' AND list = 0 AND nightplace <> ''", $project);
+ $query = sprintf ("SELECT COUNT(*) FROM person,junction "
+ ."WHERE person = id AND junction.project = '%s' AND list = 0 AND nightplace <> ''", $project);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {
{
global $dbh;
- $query = sprintf ("SELECT COUNT(*) FROM person WHERE project = '%s' AND list = 0 AND socialevent = 1", $project);
+ $query = sprintf ("SELECT COUNT(*) FROM person,junction "
+ ."WHERE person = id AND junction.project = '%s' AND list = 0 AND socialevent = 1", $project);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {
}
$query = sprintf ("SELECT name,email,list,socialevent,person.oid FROM person,junction "
- ."WHERE person = name AND junction.project = '%s' ORDER BY name", $project);
+ ."WHERE person = id AND junction.project = '%s' ORDER BY name", $project);
$sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
if (pg_NumRows ($sth) > 0) {