php connection query: <?php #include('DB/pgsql.php'); $dbconnect = pg_connect("dbname=campus user=apache"); $result = pg_exec ($conn, "select * from friends"); if (!result) {printf ("Error\n"); exit;} $numrows = pg_num_rows($result); for ($i=0; $i < $numrows; $i++) { $r = pg_fetch_row($result, $i); for ($j=0; $j < count($r); $j++) { echo "$r[$j] "; } echo "<br>"; } pg_close($dbconnect); ?> --- dan radom <dan@xxxxxxxxx> wrote: > * Bruce Young (hbrucey@xxxxxxxxx) wrote: > > my script that does insert works correctly, but i get this error > when > > retrieving data: > > > > Warning: pg_exec(): supplied argument is not a valid PostgreSQL > link > > resource in /home/httpd/htdocs/view.php on line 115 > > > > Warning: pg_num_rows(): supplied argument is not a valid > PostgreSQL > > result resource in /home/httpd/htdocs/view.php on line 118 > > > > how about showing us the connection and query parts of view.php > > dan > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister > command > (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx) __________________________________________________ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/