Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A8CC2475A3F for ; Thu, 30 Jan 2003 06:09:16 -0500 (EST) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by postgresql.org (Postfix) with SMTP id E50384758E6 for ; Thu, 30 Jan 2003 06:09:15 -0500 (EST) Received: (qmail 13988 invoked by uid 417); 30 Jan 2003 11:09:18 -0000 Received: from shunt-smtp-out-0 (HELO softhome.net) (172.16.3.12) by shunt-smtp-out-0 with SMTP; 30 Jan 2003 11:09:18 -0000 Received: from supercable ([217.216.221.248]) (AUTH: LOGIN adriantineo@softhome.net) by softhome.net with esmtp; Thu, 30 Jan 2003 04:09:12 -0700 Message-ID: <005f01c2c850$4cc1bfa0$f8ddd8d9@supercable.es> From: "Adrian Tineo" To: "ryanne cruz" , pgsql-php@postgresql.org References: <1043909588.3e38cbd4354ca@mail.up.edu.ph> Subject: Re: problem with select option Date: Thu, 30 Jan 2003 12:10:56 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/93 X-Sequence-Number: 1838 This seems to be an HTML issue since you say the records are shown right. Try to put the tags between . The problem with html is that it gives you now warnings. How I wish you had to compile HTML!! Similar issues have had me occupied for hours... besides some structures will work in a browser but not in the other. Try on static html until you know it works, then try the script. Adrian Tineo > hi list. > > i have a script that works initially. here is the script: > > $conn=pg_connect("host=127.0.0.1 dbname=db user=name password=pword"); > if (!$conn){ > echo("

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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org