Re: php cgi install

Try inserting the following statements after each and every mysql functions and see what is going on. echo mysql_errno().": ".mysql_error()."<BR>"; Then, you should get a better indication of what is actually going. I suspect that mysql_connect is already failing to start with. Regards, Nat ----- Original Message ----- From: "Bert Goodman" <bert@americanabooks.com> To: <php-install@lists.php.net> Sent: Friday, January 12, 2001 5:41 AM Subject: [PHP-INST] php cgi install OK, so I've gone ahead and done a fresh install of RH 7.0. I went and go the most recent versions of MySQL and PHP that I could find. Here is what I did to configure both of em: MySQL is compiled first with: configure --prefix=/usr/local/mysql make make install Next PHP is tackled configure --with-mysql=/usr/local/mysql make make install I then do a mysql_install_db and then start the mysql daemon. All of these tasks seem to compete. I write a simple script. Here is the whole thing: #!/usr/local/bin/php -q <?php echo "Hello World\n"; mysql_connect("localhost","root"); mysql_select_db("ingram"); $result=mysql_queary("SELECT * FROM books WHERE ISBN LIKE '0000%'"); echo "Title is: mysql_result($result,1,'TITLE'); ?> Everything works fine until I add the mysql_queary statement. If I just have: echo "Hello World\n"; mysql_connect("localhost","root"); mysql_select_db("ingram"); and run this I get no errors or warnings. Why can't I queary my MySQL database? Can I not see the forsest for the trees? ;-) Any help would be greatly appreciated. Bert Goodman