RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
The error is in your function pg_connect pg_connect(name=auth user=auth); I'm not a PostgreSQL user but your connection string should be enclosed into by quotes. Documentation can be found at http://us3.php.net/manual/en/function.pg-connect.php Hope this helps, Robbert -Original

RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
is the following. Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user auth in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Could not connect Thomas Robbert van Andel wrote: The error is in your function pg_connect pg_connect(name

RE: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Robbert van Andel
/secretdb.php on line 10 Could not connect Thomas Robbert van Andel wrote: You might need to include the hostname and port. -Original Message- From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday, June 26, 2005 6:48 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Re

RE: [PHP-DB] Using PHP to import a DB

2005-11-05 Thread Robbert van Andel
. My personal preference is phpmyadmin. It's a very good database interface and can be retrieved from http://www.phpmyadmin.net/home_page/ Robbert van Andel -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: Saturday, November 05, 2005 4:02 PM To: php-db@lists.php.net Cc

RE: [PHP-DB] Using PHP to import a DB

2005-11-06 Thread Robbert van Andel
that produces an error. Maybe the problem is that I FTP'd the file to the shared server and it should be on my local computer?? What have I overlooked? Todd Robbert van Andel wrote: You could run a system command from the web browser to import the text file. If you have access to PHPmyAdmin

RE: [PHP-DB] Using PHP to import a DB

2005-11-06 Thread Robbert van Andel
Robbert van Andel wrote: You could run a system command from the web browser to import the text file. If you have access to PHPmyAdmin, you could use it to then import the file. Or finally, you should be able to read the contents of the file into a variable (if it's small enough) and then run

RE: [PHP-DB] SELECT html table

2005-12-04 Thread Robbert van Andel
the limit statement (assuming you're using a DBMS that supports it). Hopefully this helps, Robbert van Andel -Original Message- From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED] Sent: Sunday, December 04, 2005 10:39 AM To: PHP DB Subject: [PHP-DB] SELECT html table I have two questions