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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: syntax for option select

--e5GLnnZ8mDMEwH4V
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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

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

--=20

Victor Yegorov

--e5GLnnZ8mDMEwH4V
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+gIP42RKGLEykUDYRAsWpAKC2OgJvT3GdvRwvssRtfSWy31KudACg qmYd
bZ63ax2Xgzp582xHCAM0+ks=
=VEDB
-----END PGP SIGNATURE-----

--e5GLnnZ8mDMEwH4V--

Re: syntax for option select

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


Kode Fakultas
select kode_fak
$query1="select kode_fak, nama_fak from fakultas";
$query_result1 = pg_query($conn, $query1);
while ($row1 = pg_fetch_array($query_result1))
{
echo " value=\"$row1[kode_fak]"\>$row1[nama_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



>
> * Ahmad Sentri [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
>


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)