Postgres Pro
Downloads
Home   >   mailing lists

Thread: What's wrong with this?

What's wrong with this?

From
John Poltorak
Date:
I'm trying to get a few lines of PHP working which a couple of
people have kindly provided and I can't get it to work.


Here's all it consists of:-

<HTML>
<HEAD>
<TITLE>pg_test</TITLE>
</HEAD>
<BODY>
<?

$connectid = pg_connect("194.164.53.200", "5432", "postgres");

$query = "SELECT townName FROM towns";

$result = pg_exec($connectid, $query);

$row = pg_fetch_array($result,$row);

print($row["townName"]);


?>


If I use a numeric constant, as in:-

print($row[0]);

it works.

Any ideas on what is missing here?

BTW this PHP script should be runnable by anyone on the Internet.

Maybe the problem is due to cross-platform issues...


--
John

Re: What's wrong with this?

From
Chris
Date:
>I'm trying to get a few lines of PHP working which a couple of
>people have kindly provided and I can't get it to work.
>
>
>Here's all it consists of:-
>
><? $connectid = pg_connect("194.164.53.200", "5432", "postgres"); $query =
>"SELECT townName FROM towns"; $result = pg_exec($connectid, $query); $row
>= pg_fetch_array($result,$row); print($row["townName"]); ?> If I use a
>numeric constant, as in:- print($row[0]); it works. Any ideas on what is
>missing here? BTW this PHP script should be runnable by anyone on the
>Internet. Maybe the problem is due to cross-platform issues... -- John

I don't think you need the quotes around the fieldname -
print($row[townName]);
or try single quotes - print($row['townName']);
its not a cross-platform thing, its a php syntax thing.

HTH

------------------------
Chris Smith
http://www.squiz.net