make form list with option select

Поиск
Список
Период
Сортировка
Искать

make form list with option select

От:
Ahmad Sentri <sentri@unila.ac.id>
Дата:

hi .. 
this my problem with php-postgresql
 

this syntax php with postgresql ....
this syntax still wrong / error 
in my form doesn't list ... 


Kode Fakultas
  select kode_fak\n";
           }

?>




table in postgresql 


CREATE TABLE FAKULTAS (KODE_FAK CHAR (1)NOT NULL,
                        NAMA_FAK VARCHAR (50),
                        NAMA_FAK_EN  VARCHAR (50),
                        CONSTRAINT XPKFAKULTAS
                        PRIMARY KEY (KODE_FAK));
help me please ...
thank's 
newbie php-postgresql

Re: make form list with option select

От:
apz <apz@nofate.com>
Дата:
Ahmad Sentri wrote:
> this syntax php with postgresql ....
> this syntax still wrong / error 
> in my form doesn't list ... 

I am assuming that $conn is created somewhere above ok

>          $query1="select kode_fak, nama_fak from fakultas";
>         $query_result1 = pg_query($conn, $query1);
>            while ($row1 = pg_fetch_array($query_result1))
>         {
>                 echo "\n";
>            }
> 
> ?>

first thing I would think of is how you access $row1

1. prolly you meant $row1["kode_fak"]
    you should quote your keyname, otherwise php thinks its something
    special, not a variable, not a string

2. I think its more obvious for compiler if you do it more explicitly:

    echo "

Re: make form list with option select

От:
apz <apz@nofate.com>
Дата:
apz screwed up:
>    echo "\n";


if you dont see it, I had ".>" while should be "'>"  (to close the html 
value string for the option tag). blah, hope this does not deter from 
getting this thing for you to work.


enjoy



/apz,   Learn to pause -- or nothing worthwhile can catch up to you.

Re: make form list with option select

От:
Ray Hunter <rhunter@venticon.com>
Дата:
Вложения:
Or you could just do this to:

echo 
"\n";

That will work too...

--
Ray


On Tue, 2003-03-25 at 23:59, apz wrote:
> apz screwed up:
> >    echo "\n";
> 
> 
> if you dont see it, I had ".>" while should be "'>"  (to close the html 
> value string for the option tag). blah, hope this does not deter from 
> getting this thing for you to work.
> 
> 
> enjoy
> 
> 
> 
> /apz,   Learn to pause -- or nothing worthwhile can catch up to you.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
FAQ