/[webwml]/newmaint/whoisam.wml
ViewVC logotype

Contents of /newmaint/whoisam.wml

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.5 - (hide annotations) (download)
Thu Mar 14 02:14:00 2002 UTC (11 years, 2 months ago) by tbm
Branch: MAIN
Changes since 1.4: +12 -9 lines
Open DB only once (in main, instead of in the function).  Apparently, it
doesn't work when you try to open it two times (for each SQL query).
1 csmall 1.1 <?
2     include("config.inc");
3     include("common.inc");
4    
5 tbm 1.5 function print_applicants($db, $sql) {
6 csmall 1.1 if (! ($query = pg_exec($db, $sql))) {
7     echo "Problem with query", pg_ErrorMessage($db), "<BR>";
8     pg_Close($db);
9     return FALSE;
10     }
11     $rows = pg_NumRows($query);
12     for ($i = 0 ; $i < $rows ; $i++) {
13     $row = pg_Fetch_Array($query, $i);
14 csmall 1.2 echo $row["name"], "<BR>\n";
15 csmall 1.1 }
16     return TRUE;
17     }?>
18     #use wml::nmpage title="Debian New Maintainer - Application Manager List"
19 tbm 1.5 <?
20     if (! ($db = open_db())) {
21     echo "Cannot open database!";
22     return FALSE;
23     }
24     ?>
25 csmall 1.1 <H1>Debian New Maintainer - Application Manager List</H1><BR>
26 tbm 1.4 <P>Below is the list of Debian maintainers who are currently active as
27     Application Managers:
28 csmall 1.1 <BR>
29 tbm 1.4 <? $sql = "SELECT * from manager WHERE is_active IS TRUE ORDER by name";
30 tbm 1.5 print_applicants($db, $sql); ?>
31 tbm 1.4 <P>
32     <P>Below is the list of Debian maintainers who used to help as Application
33     Managers in the past:
34     <BR>
35     <? $sql = "SELECT * from manager WHERE is_active IS FALSE ORDER by name";
36 tbm 1.5 print_applicants($db, $sql); ?>
37     <?
38     pg_Close($db);
39     ?>
40 tbm 1.4

  ViewVC Help
Powered by ViewVC 1.1.5