ot;\n";
}
As for the limiting of rows, you would use 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
M',20040521111332);
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, you could use it to then import the
file.
> Or finally, you should be able to read the contents of the file into a
> va
file
("/tmp/mybackup.sql"), however 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 im
query.
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.
Connection refused Is the server running on host
> "thomas.example.com" and accepting TCP/IP connections on port 5432? in
> /var/www/html/thomas/cis166ae/database/secretdb.php on line 10
> Could not connect
>
> Thomas
>
>
>
> Robbert van Andel wrote:
>
:
Login
And now the error I get 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
R
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 Message--
