Re: problem with select option

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux