Re: Postgres access using PHP3

John,
What you will need to do is create a table that has the
town names in it.
Example:

CREATE TABLE towns
(
town_id serial,
townName text,
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
types.

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))
{
    echo "<option
value=\"".$row["townName"]."\">".$row["townName"]."</option>";
}
echo "</SELECT>";

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.

--Andy


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
> SELECT.
>
> 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
>
> --
> John
>
>   ------------------------------------------------------------------------
>
>    M:\repository\$$$.CDs\CORE_PHP\EXAMPLES\18-11.php3Name: M:\repository\$$$.CDs\CORE_PHP\EXAMPLES\18-11.php3
>                                                      Type: Plain Text (text/plain)