pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
syntax 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