pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedsyntax for option select
3+ messages / 2 participants
[nested] [flat]
* syntax for option select
@ 2003-03-25 16:13 Ahmad Sentri <sentri@unila.ac.id>
2003-03-25 16:29 ` Re: syntax for option select Victor Yegorov <viy@pirmabanka.lv>
0 siblings, 1 reply; 3+ messages in thread
From: Ahmad Sentri @ 2003-03-25 16:13 UTC (permalink / raw)
To: pgsql-php
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: syntax for option select
2003-03-25 16:13 syntax for option select Ahmad Sentri <sentri@unila.ac.id>
@ 2003-03-25 16:29 ` Victor Yegorov <viy@pirmabanka.lv>
2003-03-26 03:37 ` Re: syntax for option select Ahmad Sentri <sentri@unila.ac.id>
0 siblings, 1 reply; 3+ messages in thread
From: Victor Yegorov @ 2003-03-25 16:29 UTC (permalink / raw)
To: Ahmad Sentri <sentri@unila.ac.id>; +Cc: pgsql-php
* 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: syntax for option select
2003-03-25 16:13 syntax for option select Ahmad Sentri <sentri@unila.ac.id>
2003-03-25 16:29 ` Re: syntax for option select Victor Yegorov <viy@pirmabanka.lv>
@ 2003-03-26 03:37 ` Ahmad Sentri <sentri@unila.ac.id>
0 siblings, 0 replies; 3+ messages in thread
From: Ahmad Sentri @ 2003-03-26 03:37 UTC (permalink / raw)
To: Victor Yegorov <viy@pirmabanka.lv>; +Cc: pgsql-php
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-03-26 03:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-03-25 16:13 syntax for option select Ahmad Sentri <sentri@unila.ac.id>
2003-03-25 16:29 ` Victor Yegorov <viy@pirmabanka.lv>
2003-03-26 03:37 ` Ahmad Sentri <sentri@unila.ac.id>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox