php cgi install

From: Date: Thu, 11 Jan 2001 20:43:42 +0000
Subject: php cgi install
Groups: php.install 
Request: Send a blank email to php-install+get-1560@lists.php.net to get a copy of this message
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 with safe_mysqld. I test to see if I can connect to the mysql daemon and it works. I can start mysql and look at the table I have created. 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

« previous php.install (#1560) next »