Thread: syntax for option select

hii ..

i want make a form list
and my data list from one colom in a table
i had create table faculty
and a field in this table was kode_fakulty,name_fakulty

and in my form list i want list my kode_fakulty from table fakulty
in php-postgresql i was try to create these syntax
so ...

if we run my localhost in webserver
always syntax error or my list can't contain data

thank's
newbie in php-postgresql

* Ahmad Sentri <sentri@unila.ac.id> [25.03.2003 18:18]:
>
> hii ..
>
> i want make a form list
> and my data list from one colom in a table
> i had create table faculty
> and a field in this table was kode_fakulty,name_fakulty
>
> and in my form list i want list my kode_fakulty from table fakulty
> in php-postgresql i was try to create these syntax
> so ...
>
> if we run my localhost in webserver
> always syntax error or my list can't contain data
>
> thank's
> newbie in php-postgresql

Please, give full CREATE TABLE statement for your table.
Also, part of your PHP script, that generates error is needed.

--

Victor Yegorov

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


<th width="20%" align="left" nowrap>Kode Fakultas</th>
  <td width="72%"><select name="kode_fak">select kode_fak<option>
<?php
    $query1="select kode_fak, nama_fak from fakultas";
    $query_result1 = pg_query($conn, $query1);
       while ($row1 = pg_fetch_array($query_result1))
    {
            echo "<option
value=\"$row1[kode_fak]"\>$row1[nama_fak]</option>\n";
       }

?>
</select>
</td>


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



>
> * Ahmad Sentri <sentri@unila.ac.id> [25.03.2003 18:18]:
> >
> > hii ..
> >
> > i want make a form list
> > and my data list from one colom in a table
> > i had create table faculty
> > and a field in this table was kode_fakulty,name_fakulty
> >
> > and in my form list i want list my kode_fakulty from table fakulty
> > in php-postgresql i was try to create these syntax
> > so ...
> >
> > if we run my localhost in webserver
> > always syntax error or my list can't contain data
> >
> > thank's
> > newbie in php-postgresql
>
> Please, give full CREATE TABLE statement for your table.
> Also, part of your PHP script, that generates error is needed.
>
> --
>
> Victor Yegorov
>