[PHP] PostgreSQL query taking a long time

Hello all, I have a PostgreSQL database that is storing The Bible. It has 31,103 records in it and I have a PHP page executing this query: SELECT books.book_name, bible.chapter, bible.verse, bible.versetext FROM asv_bible bible, book_bible books WHERE bible.book = books.id ORDER BY random() LI

[PHP] Easiest Way to Upgrade PHP

Hello all, Quick question. I'm wondering what the easiest way to upgrade PHP is? For instance, right now I have PHP 3 installed on a RH6.1 box and would like to upgrade to the latest version. Even though it was installed using RPMs can I use the tar.gz and build it to apply the upgrade? An

Re: [PHP] Problem getting PostgreSQL to compile

es, everything seems ok. Any ideas? >From: The Hermit Hacker <[EMAIL PROTECTED]> >To: K Old <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> >Subject: Re: [PHP] Problem getting PostgreSQL to compile >Date: Fri, 2 Mar 2001 22:30:11 -0400 (A

[PHP] Problem getting PostgreSQL to compile

Hello, I'm running RH 7 and Apache. I have the latest version of PostgreSQL and it is installed and running correctly. I have installed PHP with the --with-pgsql and it seems to install everything needed, but when I try to use pg_connect() it fails to connect. Any ideas what I can do? Than