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);
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
