[PHP] Weird intermittent No Database Selected problem
I apologize...I just posted this to the database list but then realized it
may not be a database issue, so thought I'd better give it a shot over here.
Help!
I've been having a weird problem today (and maybe it's been there all along,
just haven't noticed...it's only been live a few days). I have a web page
that allows users to query my database by either subject or alphabet (A-Z).
Today (and I think I noticed it once before but didn't pay much attention),
if you do a query, the first time it comes back with the results. The
second time, clicking the same letter (or sometimes other letters), for
instance, it comes back with a Database Not Selected error. Or, every
time in a row for a dozen times it comes back with a Database Not Selected
error. Or, sometimes it comes back with the results just fine for twenty
times in a row. Or, ...
You get the idea. It doesn't happen all the time, just sometimes, and in no
particular order. Very strange because I'm not changing a dang thing.
Anyway, I've already tried rebooting the server, no change. And, I've tried
accessing the web page from other machines, same problem. Has anyone ever
run into this?
I'm running Red Hat 7.2, Apache 1.3.23, MySQL 3.23.49a, and PHP 4.2.1.
Here's the code in the web page with only some name changes (for security,
ya know):
?php
function Query()
{
global $mydb, $recordset, $total_rows, $letter;
$letter = $_GET['letter'];
mysql_select_db($database_mydb, $mydb);
$query = sprintf(SELECT name
FROM tbl_mytable
WHERE name LIKE %s
ORDER BY name ASC,
SQLStr($letter . %, text));
$recordset = mysql_query($query, $mydb) or die(mysql_error());
$total_rows = mysql_num_rows($recordset);
}
?
And then the code in my include where I keep all the db connection stuff:
?php
$hostname_mydb = localhost;
$database_mydb = mydb;
$username_mydb = user;
$password_mydb = ;
$mydb= mysql_pconnect($hostname_mydb, $username_mydb, $password_mydb) or
die(mysql_error());
?
Any help is appreciated!! Thanks!
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Weird intermittent No Database Selected problem
I assume you're not checking the status returned by the
database function calls, becuase they'd probably give
you valueable information on *why* it's doing that. :)
try checking the return val, and (if using mysql) print
out mysql_error() if you get a bad return val.
---
Scott Hurring
Systems Programmer
EAC Corporation
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
-Original Message-
From: Jeff Field [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Weird intermittent No Database Selected problem
I apologize...I just posted this to the database list but
then realized it
may not be a database issue, so thought I'd better give it a
shot over here.
Help!
I've been having a weird problem today (and maybe it's been
there all along,
just haven't noticed...it's only been live a few days). I
have a web page
that allows users to query my database by either subject or
alphabet (A-Z).
Today (and I think I noticed it once before but didn't pay
much attention),
if you do a query, the first time it comes back with the results. The
second time, clicking the same letter (or sometimes other
letters), for
instance, it comes back with a Database Not Selected error.
Or, every
time in a row for a dozen times it comes back with a
Database Not Selected
error. Or, sometimes it comes back with the results just
fine for twenty
times in a row. Or, ...
You get the idea. It doesn't happen all the time, just
sometimes, and in no
particular order. Very strange because I'm not changing a dang thing.
Anyway, I've already tried rebooting the server, no change.
And, I've tried
accessing the web page from other machines, same problem.
Has anyone ever
run into this?
I'm running Red Hat 7.2, Apache 1.3.23, MySQL 3.23.49a, and PHP 4.2.1.
Here's the code in the web page with only some name changes
(for security,
ya know):
?php
function Query()
{
global $mydb, $recordset, $total_rows, $letter;
$letter = $_GET['letter'];
mysql_select_db($database_mydb, $mydb);
$query = sprintf(SELECT name
FROM tbl_mytable
WHERE name LIKE %s
ORDER BY name ASC,
SQLStr($letter . %, text));
$recordset = mysql_query($query, $mydb) or
die(mysql_error());
$total_rows = mysql_num_rows($recordset);
}
?
And then the code in my include where I keep all the db
connection stuff:
?php
$hostname_mydb = localhost;
$database_mydb = mydb;
$username_mydb = user;
$password_mydb = ;
$mydb= mysql_pconnect($hostname_mydb, $username_mydb,
$password_mydb) or
die(mysql_error());
?
Any help is appreciated!! Thanks!
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Weird intermittent No Database Selected problem
Are all the variables needed for the function getting into your
call_user_func()? Also, perhaps some aren't set or are being unset outside
your function--say, you are opening a new page and not passing all the
variables to it. The function (which apparently works) isn't getting set
variables. Try echoing the input variables just above the function call and
see if they're all there.
Hope this helps,
Hugh
- Original Message -
From: Jeff Field [EMAIL PROTECTED]
To: Php-General (E-mail) [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 2:34 PM
Subject: RE: [PHP] Weird intermittent No Database Selected problem
Hmmm...not sure how to check the status of the db function calls (sorry,
I'm
relatively new to PHP, help on this is appreciated), but I did add the
following to the script:
echo Error . mysql_errno ( ). : . mysql_error ( );
It prints out Error 0: when the script runs just fine, but nothing when
the page comes back with No Database Selected.
Any thoughts? Thanks!
Jeff
-Original Message-
From: Scott Hurring [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:15 PM
To: Php-General (E-mail)
Subject: RE: [PHP] Weird intermittent No Database Selected problem
I assume you're not checking the status returned by the
database function calls, becuase they'd probably give
you valueable information on *why* it's doing that. :)
try checking the return val, and (if using mysql) print
out mysql_error() if you get a bad return val.
---
Scott Hurring
Systems Programmer
EAC Corporation
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
-Original Message-
From: Jeff Field [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Weird intermittent No Database Selected problem
I apologize...I just posted this to the database list but
then realized it
may not be a database issue, so thought I'd better give it a
shot over here.
Help!
I've been having a weird problem today (and maybe it's been
there all along,
just haven't noticed...it's only been live a few days). I
have a web page
that allows users to query my database by either subject or
alphabet (A-Z).
Today (and I think I noticed it once before but didn't pay
much attention),
if you do a query, the first time it comes back with the results. The
second time, clicking the same letter (or sometimes other
letters), for
instance, it comes back with a Database Not Selected error.
Or, every
time in a row for a dozen times it comes back with a
Database Not Selected
error. Or, sometimes it comes back with the results just
fine for twenty
times in a row. Or, ...
You get the idea. It doesn't happen all the time, just
sometimes, and in no
particular order. Very strange because I'm not changing a dang thing.
Anyway, I've already tried rebooting the server, no change.
And, I've tried
accessing the web page from other machines, same problem.
Has anyone ever
run into this?
I'm running Red Hat 7.2, Apache 1.3.23, MySQL 3.23.49a, and PHP 4.2.1.
Here's the code in the web page with only some name changes
(for security,
ya know):
?php
function Query()
{
global $mydb, $recordset, $total_rows, $letter;
$letter = $_GET['letter'];
mysql_select_db($database_mydb, $mydb);
$query = sprintf(SELECT name
FROM tbl_mytable
WHERE name LIKE %s
ORDER BY name ASC,
SQLStr($letter . %, text));
$recordset = mysql_query($query, $mydb) or
die(mysql_error());
$total_rows = mysql_num_rows($recordset);
}
?
And then the code in my include where I keep all the db
connection stuff:
?php
$hostname_mydb = localhost;
$database_mydb = mydb;
$username_mydb = user;
$password_mydb = ;
$mydb= mysql_pconnect($hostname_mydb, $username_mydb,
$password_mydb) or
die(mysql_error());
?
Any help is appreciated!! Thanks!
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Weird intermittent No Database Selected problem
Thanks for the help, all! Here was the problem...I think, I'm pretty sure,
eh?
In mysql_select_db($database_mydb, $mydb), I have the variable,
$database_mydb, which is actually something that Macromedia's Dreamweaver
MX created (for those that don't know it, Dreamweaver MX supports a little
PHP).
Well, not to put the blame on Macromedia, it was all my fault and I now feel
a bit stupid, I think it all boiled down to $database_mydb not being
declared global in the function I wrote to do the query.
Funny that it worked probably 95% of the time. Must have been due to
mysql_pconnect or something holding open previous connections to the db and
the script just connecting to the last connected db. Anyway...
Sorry for the trouble!
Jeff
-Original Message-
From: hugh danaher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 5:37 PM
To: [EMAIL PROTECTED]
Cc: php
Subject: Re: [PHP] Weird intermittent No Database Selected problem
Are all the variables needed for the function getting into your
call_user_func()? Also, perhaps some aren't set or are being
unset outside
your function--say, you are opening a new page and not passing all the
variables to it. The function (which apparently works) isn't getting set
variables. Try echoing the input variables just above the
function call and
see if they're all there.
Hope this helps,
Hugh
- Original Message -
From: Jeff Field [EMAIL PROTECTED]
To: Php-General (E-mail) [EMAIL PROTECTED]
Sent: Thursday, June 06, 2002 2:34 PM
Subject: RE: [PHP] Weird intermittent No Database Selected problem
Hmmm...not sure how to check the status of the db function calls (sorry,
I'm
relatively new to PHP, help on this is appreciated), but I did add the
following to the script:
echo Error . mysql_errno ( ). : . mysql_error ( );
It prints out Error 0: when the script runs just fine, but
nothing when
the page comes back with No Database Selected.
Any thoughts? Thanks!
Jeff
-Original Message-
From: Scott Hurring [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:15 PM
To: Php-General (E-mail)
Subject: RE: [PHP] Weird intermittent No Database Selected problem
I assume you're not checking the status returned by the
database function calls, becuase they'd probably give
you valueable information on *why* it's doing that. :)
try checking the return val, and (if using mysql) print
out mysql_error() if you get a bad return val.
---
Scott Hurring
Systems Programmer
EAC Corporation
[EMAIL PROTECTED]
Voice: 201-462-2149
Fax: 201-288-1515
-Original Message-
From: Jeff Field [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 06, 2002 4:58 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Weird intermittent No Database Selected problem
I apologize...I just posted this to the database list but
then realized it
may not be a database issue, so thought I'd better give it a
shot over here.
Help!
I've been having a weird problem today (and maybe it's been
there all along,
just haven't noticed...it's only been live a few days). I
have a web page
that allows users to query my database by either subject or
alphabet (A-Z).
Today (and I think I noticed it once before but didn't pay
much attention),
if you do a query, the first time it comes back with the
results. The
second time, clicking the same letter (or sometimes other
letters), for
instance, it comes back with a Database Not Selected error.
Or, every
time in a row for a dozen times it comes back with a
Database Not Selected
error. Or, sometimes it comes back with the results just
fine for twenty
times in a row. Or, ...
You get the idea. It doesn't happen all the time, just
sometimes, and in no
particular order. Very strange because I'm not changing a
dang thing.
Anyway, I've already tried rebooting the server, no change.
And, I've tried
accessing the web page from other machines, same problem.
Has anyone ever
run into this?
I'm running Red Hat 7.2, Apache 1.3.23, MySQL 3.23.49a, and
PHP 4.2.1.
Here's the code in the web page with only some name changes
(for security,
ya know):
?php
function Query()
{
global $mydb, $recordset, $total_rows, $letter;
$letter = $_GET['letter'];
mysql_select_db($database_mydb, $mydb);
$query = sprintf(SELECT name
FROM tbl_mytable
WHERE name LIKE %s
ORDER BY name ASC,
SQLStr($letter . %, text));
$recordset = mysql_query($query, $mydb) or
die(mysql_error());
$total_rows = mysql_num_rows($recordset);
}
?
And then the code in my include where I keep all the db
connection stuff:
?php
$hostname_mydb = localhost;
$database_mydb = mydb;
$username_mydb = user;
$password_mydb =
