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:scott@eacnet.com] > 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 > ScottH@eac.com > Voice: 201-462-2149 > Fax: 201-288-1515 > > > -----Original Message----- > > From: Jeff Field [mailto:jfield@aaaq.com] > > Sent: Thursday, June 06, 2002 4:58 PM > > To: php-general@lists.php.net > > 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 = "xxxxxxxx"; > > $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 > >