What you will need to do is create a table that has the
town names in it.
CREATE TABLE towns
PRIMARY KEY(town_id, townName)
SO... your query would look something like
SELECT townName FROM towns;
I never used the pgsql functions in php so you will
have to look those up on php.net, I normally use
phpLib which allows me to write for many different DB
But I think it would look something like:
$query = "SELECT townName FROM towns";
$result = pg_exec($connectid, $query);
echo "<SELECT NAME=\"towns\">";
while($row = pg_fetch_array($result))
The above, (keep in mind my pgsql functions may be off), but that should
print out your list of townNames in a option list.
Hope this helps.
John Poltorak wrote:
> On Fri, Jan 19, 2001 at 04:13:21PM -0500, Andy Holman wrote:
> > John,
> > Not sure exactly what you mean. Do you know the
> > column names to the table in the db or is that
> > what you are trying to get? Or do you mean you
> > are just trying to print out the results of a
> > query into a drop down list?
> > Let me know and I will give you some code.
> Hi Andy,
> I'm going to attach some sample PHP code which hopefully illustrates
> what I mean...
> The the first selection offers a list of monthnames. What I want to
> do instead is provide a list of values from a table ie such as towns.
> The selected town will then be used for the WHERE clause in a subsequent
> I hope you understand what I'm getting at.
> > --Andy
> > John Poltorak wrote:
> > >
> > > I'm trying out PHP3 for accesing Postgres through a Web interface
> > > and am having a problem coming up with the correct code...
> > >
> > > I'd like to retreive a list of values for a key field and then
> > > provide this to the user in the form of a drop down selection list,
> > > but I can't work out how to get the values into an array.
> > >
> > > I must be missing something as I can't a way of doing it...
> > >
> > > Any sample code snippets would be much appreciated.
> > >
> > > --
> > > John
> M:\repository\$$$.CDs\CORE_PHP\EXAMPLES\18-11.php3Name: M:\repository\$$$.CDs\CORE_PHP\EXAMPLES\18-11.php3
> Type: Plain Text (text/plain)
In response to
pgsql-novice by date
|Next:||From: Stefan Waidele jun.||Date: 2001-01-19 22:16:56|
|Subject: Re: Re: Interval output format |
|Previous:||From: Albert REINER||Date: 2001-01-19 22:09:31|
|Subject: Index on function referring other table|