Thread: Re: problem with select option

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

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