Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D4446475B33 for ; Thu, 30 Jan 2003 01:38:52 -0500 (EST) Received: from mail02.up.edu.ph (unknown [210.14.43.1]) by postgresql.org (Postfix) with SMTP id 5840C47595A for ; Thu, 30 Jan 2003 01:38:51 -0500 (EST) Received: (qmail 21128 invoked by uid 504); 30 Jan 2003 07:10:38 -0000 Received: from ryanne.cruz@up.edu.ph by web2 with qmail-scanner-1.01 (update: v4245 29 Jan 2003. Clean. Processed in 0.459706 secs); 30 Jan 2003 07:10:38 -0000 Received: from unknown (HELO b01.mail.up.edu.ph) (10.16.3.1) by 10.16.3.144 with SMTP; 30 Jan 2003 07:10:37 -0000 Received: (qmail 31671 invoked by uid 504); 30 Jan 2003 06:42:49 -0000 Received: from ryanne.cruz@up.edu.ph by b01 with qmail-scanner-1.01 (update: v4245 29 Jan 2003. Clean. Processed in 0.542327 secs); 30 Jan 2003 06:42:49 -0000 Received: from unknown (HELO localhost) ([10.16.3.5]) (envelope-sender ) by 10.16.3.1 (qmail-ldap-1.03) with SMTP for ; 30 Jan 2003 06:42:49 -0000 Received: from 10.33.187.83 ( [10.33.187.83]) as user rocruz1@b04.mail.up.edu.ph by mail.up.edu.ph with HTTP; Thu, 30 Jan 2003 14:53:08 +0800 Message-ID: <1043909588.3e38cbd4354ca@mail.up.edu.ph> Date: Thu, 30 Jan 2003 14:53:08 +0800 From: ryanne cruz To: "\\\"pgsql-php@postgresql.org\\\"" Subject: Re: problem with select option MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1 X-Originating-IP: 10.33.187.83 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/89 X-Sequence-Number: 1834 hi list. i have a script that works initially. here is the script: Unable to connect to the database server at this time.

"); exit(); } else{$query0="SELECT municipality FROM municipality where provinceid=$provid order by municipality;"; $result0=pg_exec($conn, $query0); } $numrows0=pg_numrows($result0); $CurrentRow0=0; while ($CurrentRow0 < $numrows0) { $model0=pg_result($result0, $CurrentRow0); echo ""; $CurrentRow0++; } ?> this is only part of the script. when no municipality is chosen, this still works. what i mean is that it still shows the municipalities in the drop down box. but if i choose a certain municipality, there will be no municipalities shown in the drop down box. i know there's something wrong with the script but i just can't figure it out. any ideas? thanks. ryanne