Re: [PHP-DB] Re: list test subject. .
Just a quick reply. No I am not from NZ if you were asking me, which I don't think you were because my email states I am from Australia. Just thought I'd make that said. Thanks for your informative response. J Date: Sun, 26 Jun 2005 14:05:13 -0500From:"Martin Norland" <[EMAIL PROTECTED]>To:[EMAIL PROTECTED]:Re: [PHP-DB] Re: list test subject. . Plain Text Attachment [ Download File | Save to Yahoo! Briefcase ] [[[ O-F-F topic ]]]prefer replies offlist if they have to be done, but I had to clear the waters some on this.that said...JeRRy wrote:[A lot of mostly unintelligible and worthless to quote jumble]delays like this are not frequent, and should not be.> delays like such. Most recently IP's were a major issue than they > upgraded how they operate to IP(something or rather) ... IP2 or > something. Effected Web Hosts. I'm not quite clear exactly what all > this was but my web host was down for a considerable time because of it > and all my sites effected as people could not connect. Some were > upgraded on the fly some sites were down for weeks or more. My web host > was down for 11 days.Where do you live ?No. You were handed a pile of lies, it's possible that a major line recently was upgraded or repaired. Are you in New Zealand?http://slashdot.org/article.pl?sid=05/06/24/0249231&tid=95&tid=133More likely your web host broke something badly and had to rebuild their system(s). IPv6 is the next version of IP, and it's not full replacing IPv4 anytime soon because coordinating the whole mess is cumbersome. It's already in use in plenty of places, and they use it alongside IPv4 just fine.> Australia!I know, that the USA are realy underdeveloped (Broadband,...) > but broken DNS or such issues?The USA is not really underdeveloped in this area, we are just too widespread to have *really* fast pipes. Broadband has penetrated the US quite fine and it's extremely easy to get fast always on connections> Tests were ran with certain domains. Most domains failed in Washington > area. But since these tests are not always accurate but I'd guess the > problem lays within a hop or something there. But how would I know in > Australia? > Another is I tried to load > http://www.getpaid2reademails.com/ and> I can't access it but people > elsewhere can. When I ran anonymous> browsing it works. (another > location)More bizzare!!!Your DNS was broken, you still had a local cache of the sites you frequently visit.> Not really. A person in Canada confirmed they were not able to view the > above site for the passed 3 days. I can view it now. Another person in > Americal could see it before but can't now despite the site being online > and the server active. It happens quite often this occourence.> This > list seems to be working fine now, I just got a swag of emails> sworming > in all at once. But when I see the date/time emails were> sent I see > there is quite a delay in some hitting the inboxes.Maybe you should ask > your ISP what happen...Again, DNS servers/issues. DNS changes can take a long while to propogate. If your webhost was also your DNS host and their servers went poof, it is possible some people had the lookup cached while some didn't.Email has no particular guaranteed delivery time, and backoff algorithms differ - in addition to mail servers queuing mail up before sending. It happens, mail isn't always as instant as we would like.> Why should I? Can't you see I am using Yahoo!? lol ... Nothing wrong > with my ISP currently. As they don't feed my emails, they just feed the > pages to check them. ;) > But it's great to see people interested if the > list is still> ACTIVE... Rather than forgetting it exists if people > don't get> emails every so hours. The list has lovers.. :):-)amen. hail to the list. :)> I think there has been 2 emails stating is the list active lately. But > none have confirmed www problems. > Michelle, go back to your little > box.Little Box ?> > That's what they call a linux (of some description) O/S machine, a box. it's just OS - it's an abbreviation, not O/S like O/S 2.cheers,-- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. - Do you Yahoo!? Win a dream trip to Western Australia, courtesy of the NEW My Yahoo!
Re: [PHP-DB] Re: PostgreSQL error with PHP
I think so.
I'm going to go there my book (agin) and I'm also going to ask the head
IT guy.
Thanks for all of your help!
Thomas
Robbert van Andel wrote:
Can you log into the PostgreSQL server from the console or command line?
Are you sure you are using the right username, password or host?
-Original Message-
From: Thomas Bonham [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 26, 2005 8:03 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP
I rewrote the code. This is the code and errors.
This is starting to get old, I have been working on this for over a week
now.
CODE:
Login
Error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
"localhost" and accepting TCP/IP connections on port 5432? in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 11
Connected Successfully
Thomas
Thomas Bonham wrote:
I add the hostname and port, then I configure postgresql.conf and enable
the port 5432 line in the config file.
So this is the new code.
Login
$conn = pg_connect("
user=auth dbname=auth password=redhat host=thomas.example.com
port=5432" ) or die ("Could not connect") ;
echo "Connected Successfully";
pg_close($conn);
?>
With the new error.
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: 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:
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: PostgreSQL error with PHP
Thanks for the help.
The code now looks like this.
CODE:
Login
$conn = pg_connect("user=auth dbname=auth password=redhat")
or die ("Could not connect") ;
echo "Connectd Successfully";
pg_close($conn);
?>
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
Robbert van Andel wrote:
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-
From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday,
June 26, 2005 5:43 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get
this error.
CODE:
Login
pg_connect(name="auth"); (user="auth");
?>
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
Hello All,
I'm trying to get php to connect to my PostgreSQL database.
The code that I'm using is below.
Login
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
Below is how I set up my database.
[EMAIL PROTECTED] # Su - postgres
-bash-3.00$ createuser -D -A -E
auth
-bash-3.00$ createdb auth
Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: PostgreSQL error with PHP
Can you log into the PostgreSQL server from the console or command line?
Are you sure you are using the right username, password or host?
-Original Message-
From: Thomas Bonham [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 26, 2005 8:03 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Re: PostgreSQL error with PHP
I rewrote the code. This is the code and errors.
This is starting to get old, I have been working on this for over a week
now.
CODE:
Login
Error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
"localhost" and accepting TCP/IP connections on port 5432? in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 11
Connected Successfully
Thomas
Thomas Bonham wrote:
> I add the hostname and port, then I configure postgresql.conf and enable
> the port 5432 line in the config file.
>
> So this is the new code.
>
>
>Login
>
>
>
>
> $conn = pg_connect("
> user=auth dbname=auth password=redhat host=thomas.example.com
> port=5432" ) or die ("Could not connect") ;
> echo "Connected Successfully";
> pg_close($conn);
>
>?>
>
>
>
> With the new error.
>
> Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
> connect to server: 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:
>
>> 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: PostgreSQL error with PHP
>>
>> Thanks for the help.
>> The code now looks like this.
>> CODE:
>>
>> Login
>>
>>
>>
>> >
>> $conn = pg_connect("user=auth dbname=auth password=redhat")
>> or die ("Could not connect") ;
>> echo "Connectd Successfully";
>> pg_close($conn);
>>
>> ?>
>>
>>
>>
>> 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
>>
>> Robbert van Andel wrote:
>>
>>> 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-
>>> From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday,
>>> June 26, 2005 5:43 PM
>>> To: php-db@lists.php.net
>>> Subject: [PHP-DB] Re: PostgreSQL error with PHP
>>>
>>> I modafide the code some more and now with the following code I get
>>> this error.
>>> CODE:
>>> Login
>>>
>>>
>>>
>>>>>
>>> pg_connect(name="auth"); (user="auth");
>>>?>
>>>
>>>
>>>
>>>
>>> Parse error: parse error, unexpected '=' in
>>> /var/www/html/thomas/cis166ae/database/secretdb.php on line 8
>>>
>>> Thanks
>>>
>>> Thomas Bonham wrote:
>>>
>>>
Hello All,
I'm trying to get php to connect to my PostgreSQL database.
The code that I'm using is below.
Login
>>> $conn = "dbname=auth user=auth";
$db = pg_connect ( $conn );
?>
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
Below is how I set up my database.
[EMAIL PROTECTED] # Su - postgres
-bash-3.00$ createuser -D -A -E
auth
-bash-3.00$ createdb auth
Thanks Helping
>>>
>>>
>>>
>>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PostgreSQL error with PHP
I rewrote the code. This is the code and errors.
This is starting to get old, I have been working on this for over a week
now.
CODE:
Login
Error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: Connection refused Is the server running on host
"localhost" and accepting TCP/IP connections on port 5432? in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 11
Connected Successfully
Thomas
Thomas Bonham wrote:
I add the hostname and port, then I configure postgresql.conf and enable
the port 5432 line in the config file.
So this is the new code.
Login
$conn = pg_connect("
user=auth dbname=auth password=redhat host=thomas.example.com
port=5432" ) or die ("Could not connect") ;
echo "Connected Successfully";
pg_close($conn);
?>
With the new error.
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: 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:
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: PostgreSQL error with PHP
Thanks for the help.
The code now looks like this.
CODE:
Login
$conn = pg_connect("user=auth dbname=auth password=redhat")
or die ("Could not connect") ;
echo "Connectd Successfully";
pg_close($conn);
?>
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
Robbert van Andel wrote:
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-
From: Thomas Bonham [mailto:[EMAIL PROTECTED] Sent: Sunday,
June 26, 2005 5:43 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get
this error.
CODE:
Login
pg_connect(name="auth"); (user="auth");
?>
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
Hello All,
I'm trying to get php to connect to my PostgreSQL database.
The code that I'm using is below.
Login
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
Below is how I set up my database.
[EMAIL PROTECTED] # Su - postgres
-bash-3.00$ createuser -D -A -E
auth
-bash-3.00$ createdb auth
Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PostgreSQL error with PHP
I add the hostname and port, then I configure postgresql.conf and enable
the port 5432 line in the config file.
So this is the new code.
Login
With the new error.
Warning: pg_connect(): Unable to connect to PostgreSQL server: could not
connect to server: 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:
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: PostgreSQL error with PHP
Thanks for the help.
The code now looks like this.
CODE:
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
Robbert van Andel wrote:
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-
From: Thomas Bonham [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 26, 2005 5:43 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get this
error.
CODE:
Login
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
Hello All,
I'm trying to get php to connect to my PostgreSQL database.
The code that I'm using is below.
Login
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
Below is how I set up my database.
[EMAIL PROTECTED] # Su - postgres
-bash-3.00$ createuser -D -A -E
auth
-bash-3.00$ createdb auth
Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: PostgreSQL error with PHP
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: PostgreSQL error with PHP
Thanks for the help.
The code now looks like this.
CODE:
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
Robbert van Andel wrote:
> 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-
> From: Thomas Bonham [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June 26, 2005 5:43 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Re: PostgreSQL error with PHP
>
> I modafide the code some more and now with the following code I get this
> error.
> CODE:
> Login
>
>
>
>
> pg_connect(name="auth"); (user="auth");
> ?>
>
>
>
>
> Parse error: parse error, unexpected '=' in
> /var/www/html/thomas/cis166ae/database/secretdb.php on line 8
>
> Thanks
>
> Thomas Bonham wrote:
>
>>Hello All,
>>I'm trying to get php to connect to my PostgreSQL database.
>>The code that I'm using is below.
>>
>>
>> Login
>>
>>
>>
>> > $conn = "dbname=auth user=auth";
>>$db = pg_connect ( $conn );
>> ?>
>>
>>
>>
>>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
>>
>>Below is how I set up my database.
>>
>>[EMAIL PROTECTED] # Su - postgres
>>
>>-bash-3.00$ createuser -D -A -E
>>auth
>>-bash-3.00$ createdb auth
>>
>>Thanks Helping
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PostgreSQL error with PHP
Thanks for the help.
The code now looks like this.
CODE:
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
Robbert van Andel wrote:
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-
From: Thomas Bonham [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 26, 2005 5:43 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get this
error.
CODE:
Login
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
Hello All,
I'm trying to get php to connect to my PostgreSQL database.
The code that I'm using is below.
Login
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
Below is how I set up my database.
[EMAIL PROTECTED] # Su - postgres
-bash-3.00$ createuser -D -A -E
auth
-bash-3.00$ createdb auth
Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: PostgreSQL error with PHP
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-
From: Thomas Bonham [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 26, 2005 5:43 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get this
error.
CODE:
Login
Parse error: parse error, unexpected '=' in
/var/www/html/thomas/cis166ae/database/secretdb.php on line 8
Thanks
Thomas Bonham wrote:
> Hello All,
> I'm trying to get php to connect to my PostgreSQL database.
> The code that I'm using is below.
>
>
>Login
>
>
>
>$conn = "dbname=auth user=auth";
> $db = pg_connect ( $conn );
>?>
>
>
>
> 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
>
> Below is how I set up my database.
>
> [EMAIL PROTECTED] # Su - postgres
>
> -bash-3.00$ createuser -D -A -E
> auth
> -bash-3.00$ createdb auth
>
> Thanks Helping
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PostgreSQL error with PHP
I modafide the code some more and now with the following code I get this error. CODE: Login Parse error: parse error, unexpected '=' in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Thanks Thomas Bonham wrote: Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login 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 Below is how I set up my database. [EMAIL PROTECTED] # Su – postgres -bash-3.00$ createuser –D –A –E auth -bash-3.00$ createdb auth Thanks Helping -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Efficient way to count rows when using GROUP BY
It worked! SELECT COUNT(*) FROM (SELECT COUNT(*) FROM ad.off_enrol GROUP BY jcu_campus, sub_code) t1 Thank you list -:) Martín Marqués wrote: El Dom 26 Jun 2005 07:39, Ross Honniball escribió: Hi All, I use SELECT COUNT(*) FROM whatever WHERE whatever to determine how many rows a particular query will return (then use this count to assist with pagination). The problem is that this does not work if the query contains a GROUP BY statement as, of course, the query will return many rows each with a count by each grouping. Does anyone know an efficient way to determine the number of ROWS a query with a GROUP BY statement will return (without just executing the entire query with no LIMIT statement)? You are not stating which database you are working with, but I would do this (don't know if it's efficient, but it'll work): SELECT sum(count) FROM (SELECT COUNT(*) AS count FROM whatever WHERE whatever) t1; Hope it helps. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL with php error
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login 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 Below is how I set up my database. [EMAIL PROTECTED] # Su – postgres -bash-3.00$ createuser –D –A –E auth -bash-3.00$ createdb auth Thanks Helping -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL error with PHP
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login 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 Below is how I set up my database. [EMAIL PROTECTED] # Su – postgres -bash-3.00$ createuser –D –A –E auth -bash-3.00$ createdb auth Thanks Helping -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL error with PHP
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login 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 Below is how I set up my database. [EMAIL PROTECTED] # Su – postgres -bash-3.00$ createuser –D –A –E auth -bash-3.00$ createdb auth Thanks Helping -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PostgreSQL error with php
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login 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 Below is how I set up my database. [EMAIL PROTECTED] # Su – postgres -bash-3.00$ createuser –D –A –E auth -bash-3.00$ createdb auth Thanks Helping -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Functions Installation
Ok here's a dummy question from yet another newbie: Reading the instructions for enabling the MySQL Functions, I understood until i get to this: "For compiling, simply use the --with-mysql[=DIR] configuration option where the optional [DIR] points to the MySQL installation directory. " i have a windows XP Pro OS, and im working with Apache Server 2.0 and PHP 5.0, I've never heard about compiling in Windows, so I don't know where to put the --with-mysql[=DIR] line, I suspect this is an instruction only for Unix users, if not please help me so i can start developing php pages for accesing MySQL databases. -- "Too much fantasy loses reality, too much hope may seem somehow empty" -Toriyama Akira
Re: [PHP-DB] Re: list test subject. .
[[[ O-F-F topic ]]] prefer replies offlist if they have to be done, but I had to clear the waters some on this. that said... JeRRy wrote: [A lot of mostly unintelligible and worthless to quote jumble] delays like this are not frequent, and should not be. delays like such. Most recently IP's were a major issue than they upgraded how they operate to IP(something or rather) ... IP2 or something. Effected Web Hosts. I'm not quite clear exactly what all this was but my web host was down for a considerable time because of it and all my sites effected as people could not connect. Some were upgraded on the fly some sites were down for weeks or more. My web host was down for 11 days.Where do you live ? No. You were handed a pile of lies, it's possible that a major line recently was upgraded or repaired. Are you in New Zealand? http://slashdot.org/article.pl?sid=05/06/24/0249231&tid=95&tid=133 More likely your web host broke something badly and had to rebuild their system(s). IPv6 is the next version of IP, and it's not full replacing IPv4 anytime soon because coordinating the whole mess is cumbersome. It's already in use in plenty of places, and they use it alongside IPv4 just fine. Australia!I know, that the USA are realy underdeveloped (Broadband,...) but broken DNS or such issues? The USA is not really underdeveloped in this area, we are just too widespread to have *really* fast pipes. Broadband has penetrated the US quite fine and it's extremely easy to get fast always on connections Tests were ran with certain domains. Most domains failed in Washington area. But since these tests are not always accurate but I'd guess the problem lays within a hop or something there. But how would I know in Australia? > Another is I tried to load http://www.getpaid2reademails.com/ and> I can't access it but people elsewhere can. When I ran anonymous> browsing it works. (another location)More bizzare!!! Your DNS was broken, you still had a local cache of the sites you frequently visit. Not really. A person in Canada confirmed they were not able to view the above site for the passed 3 days. I can view it now. Another person in Americal could see it before but can't now despite the site being online and the server active. It happens quite often this occourence.> This list seems to be working fine now, I just got a swag of emails> sworming in all at once. But when I see the date/time emails were> sent I see there is quite a delay in some hitting the inboxes.Maybe you should ask your ISP what happen... Again, DNS servers/issues. DNS changes can take a long while to propogate. If your webhost was also your DNS host and their servers went poof, it is possible some people had the lookup cached while some didn't. Email has no particular guaranteed delivery time, and backoff algorithms differ - in addition to mail servers queuing mail up before sending. It happens, mail isn't always as instant as we would like. Why should I? Can't you see I am using Yahoo!? lol ... Nothing wrong with my ISP currently. As they don't feed my emails, they just feed the pages to check them. ;) > But it's great to see people interested if the list is still> ACTIVE... Rather than forgetting it exists if people don't get> emails every so hours. The list has lovers.. :):-) amen. hail to the list. :) I think there has been 2 emails stating is the list active lately. But none have confirmed www problems. > Michelle, go back to your little box.Little Box ? That's what they call a linux (of some description) O/S machine, a box. it's just OS - it's an abbreviation, not O/S like O/S 2. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Efficient way to count rows when using GROUP BY
El Dom 26 Jun 2005 07:39, Ross Honniball escribió: > Hi All, > > I use > > SELECT COUNT(*) FROM whatever WHERE whatever > > to determine how many rows a particular query will return (then use this count to assist with pagination). > > The problem is that this does not work if the query contains a GROUP BY statement as, of course, > the query will return many rows each with a count by each grouping. > > Does anyone know an efficient way to determine the number of ROWS a query with a GROUP BY > statement will return (without just executing the entire query with no LIMIT statement)? You are not stating which database you are working with, but I would do this (don't know if it's efficient, but it'll work): SELECT sum(count) FROM (SELECT COUNT(*) AS count FROM whatever WHERE whatever) t1; Hope it helps. -- select 'mmarques' || '@' || 'unl.edu.ar' AS email; - Martín Marqués | Programador, DBA Centro de Telemática| Administrador Universidad Nacional del Litoral - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Efficient way to count rows when using GROUP BY
If you don't want a group count, but want a total row count instead, there's no reason to have the group by statement, If you're trying to have a conglomerate result, where one column is always equal to the total count, wouldn't it be more efficient to have a seperate query for that? -Micah > Hi All, > > I use > > SELECT COUNT(*) FROM whatever WHERE whatever > > to determine how many rows a particular query will return (then use this > count to assist with pagination). > > The problem is that this does not work if the query contains a GROUP BY > statement as, of course, the query will return many rows each with a count > by each grouping. > > Does anyone know an efficient way to determine the number of ROWS a query > with a GROUP BY statement will return (without just executing the entire > query with no LIMIT statement)? > > Thanks ... Ross -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL/PHP how to put the results of one query in another query
This is what I use when needing to do this:
1. Put all the values you want to search for in an array $vals (loop
around the first result)
2. $query = "
select count(Nome) from Aeromodelistas
where year(AnoQuota)=2005
and Sexo='Masculino' and Distrito IN ".sqlIn($vals)
;
function sqlIn($vals, $quote="'") {
if (!is_array($vals)) $vals = array($vals);
$s = '(';
$c = '';
foreach ($vals as $val) {
$s .= $c.$quote.addslashes($val).$quote;
$c = ',';
}
return $s.')';
}
Pedro Quaresma de Almeida wrote:
Hi
I have two MySQL databases, on for aeromodelistas (aeromodelling) and
another for Códigos Postais (Postal Codes). I whant to do the
following query
SELECT CódigoPostal FROM Aeromodelistas
WHERE CódigoPostal IN
(SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO
WHERE codigopostal.LOCART.DD=codigopostal.DISTRITO.DD
AND codigopostal.DISTRITO.DESIG='Coimbra');
This query is not working, and I do not know why. If I try the two
queries individualy they work, togheter they don't!?
But the question I want to put to the members of this list is the
following. Is it possible to do the following?
// first do the subquery
$sql_CP4s = "select distinct(CP4) from
codigopostal.LOCART,codigopostal.DISTRITO where
codigopostal.LOCART.DD=codigopostal.DISTRITO.DD and
codigopostal.DISTRITO.DESIG='$nomeDistrito'";
$resultado_CP4s = mysql_query($sql_CP4s,$ligacao);
$linha_CP4s = mysql_fetch_assoc($resultado_CP4s);
// then use it's results in the main query
$sql_Aero_Dist_Masc = "select count(Nome) from Aeromodelistas where
year(AnoQuota)=2005 and Sexo='Masculino' and Distrito IN $linha_CP4s";
How can we include the results (not just one) of one query in another
query?
Is it possible?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL/PHP how to put the results of one query in another query
Hi I have two MySQL databases, on for aeromodelistas (aeromodelling) and another for Códigos Postais (Postal Codes). I whant to do the following query SELECT CódigoPostal FROM Aeromodelistas WHERE CódigoPostal IN (SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO WHERE codigopostal.LOCART.DD=codigopostal.DISTRITO.DD AND codigopostal.DISTRITO.DESIG='Coimbra'); This query is not working, and I do not know why. If I try the two queries individualy they work, togheter they don't!? But the question I want to put to the members of this list is the following. Is it possible to do the following? // first do the subquery $sql_CP4s = "select distinct(CP4) from codigopostal.LOCART,codigopostal.DISTRITO where codigopostal.LOCART.DD=codigopostal.DISTRITO.DD and codigopostal.DISTRITO.DESIG='$nomeDistrito'"; $resultado_CP4s = mysql_query($sql_CP4s,$ligacao); $linha_CP4s = mysql_fetch_assoc($resultado_CP4s); // then use it's results in the main query $sql_Aero_Dist_Masc = "select count(Nome) from Aeromodelistas where year(AnoQuota)=2005 and Sexo='Masculino' and Distrito IN $linha_CP4s"; How can we include the results (not just one) of one query in another query? Is it possible? -- Pedro Henrique e Figueiredo Quaresma de Almeida -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Efficient way to count rows when using GROUP BY
Hi All, I use SELECT COUNT(*) FROM whatever WHERE whatever to determine how many rows a particular query will return (then use this count to assist with pagination). The problem is that this does not work if the query contains a GROUP BY statement as, of course, the query will return many rows each with a count by each grouping. Does anyone know an efficient way to determine the number of ROWS a query with a GROUP BY statement will return (without just executing the entire query with no LIMIT statement)? Thanks ... Ross -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
