Re: error messages (not valid postgresql link resoucre) - Mailing list pgsql-general

On Mon, 10 May 2004, Robert Morgan wrote:

> |I'm trying to run a query on a database using php and postgres functions
>
> ||<?php
> db_connect();

You don't set $connstr.

> $stat = pg_exec($connstr,"SELECT WSID from tblWorkstation ");
> while ($row = pg_fetch_rows($stat))
> {
> print("<option> $row[0]</option>");
> }
> ?>

$dblink = pg_connect("dbname=$pg_db user=$pg_userid password=$pg_password")
          or die ("Kein Connect zu DB");

$sql = "DELETE FROM adr where nr = $nr";
$result = pg_exec($dblink, $sql);