This seems to be an HTML issue since you say the records are shown right.
Try to put the <option></option> tags between <select></select>. 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:
>
> <?php
> $conn=pg_connect("host=127.0.0.1 dbname=db user=name password=pword");
> if (!$conn){
> echo("<P> Unable to connect to the database server at this time.</P>");
> 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 "<font face=\"Verdana\" size=1><option
> value=$model0>$model0</option></font>";
> $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
