Re: can't retrieve data through PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Your variables don't match.  And your coding is very inconsistent.  The if
construct should follow the for construct.  It makes everything READABLE
and understandable.
Good luck

On Sat, 26 Oct 2002, Bruce Young wrote:

> php connection query:
> 
> <?php
>         #include('DB/pgsql.php');
> 
> 	$dbconnect = pg_connect("dbname=campus user=apache");

HERE YOU HAVE DBCONNECT	

> 	
> 	
> 	$result = pg_exec ($conn, "select * from friends");	

HERE YOU HAVE CONN

> 	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]&nbsp;";
> 	   }
> 	   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/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
> 

-Chadwick



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux