Participants

"; if (!($dbconnect = pg_connect("dbname=$db_name user=$db_user"))){ echo "Error: Could not connect to database "; exit; } assertInt($event_id); $query = "SELECT * FROM event_registered WHERE event_id=$event_id ORDER BY regtime"; //echo "$query"; $result = pg_query($dbconnect, $query); if (!$result) { echo "Error: Can't make database query"; exit; } $numrows=pg_num_rows( $result ); echo "\n"; $count = 0; for ($i=0; $i < $numrows; $i++) { extract( pg_fetch_array($result, $i, PGSQL_ASSOC) ); assertInt($event_id); escape($email); $query = "SELECT COUNT (*) AS session_count FROM event_sessions WHERE event_id=$event_id AND email='$email' AND cancellation='f'"; $result1 = pg_query($dbconnect, $query); if (!$result1) continue; // Just skip this extract( pg_fetch_array($result1, 0, PGSQL_ASSOC) ); if (0 == $session_count) continue; $count++; $regtime = substr($regtime, 0, 10); echo ""; } echo "

No.	Name	Affialiation	Position
$count	$firstname $lastname	$affiliation	$position

"; pg_close ($dbconnect); print ""; print ""; layout_close(); ?>