Re: php cgi install

I may be a little off base here... But shouldnt that read "mysql_query" not "mysql_queary" ?? Unless they have differant spellings somewhere this could very easily be your problem -- Webmaster AngelHaven.com Nat Sakimura wrote: > > 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 > > -- > PHP Install Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net > For additional commands, e-mail: php-install-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -------------------------------------------------- This holiday season give the gift of love. Shop AngelHaven.com http://store.angelhaven.com