Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Jim Michaels
March 26, 2006, 7:34 am
rate this thread
I am using mysql_connect() without any fancy options to connect to MySQL and
do some stuff without using mysql_close() at the end, and debugging several
files in sequence.
I eventually run into
PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link
e in C:\prj\quiz\withusers\header.php on line 28
PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
resource in C:\prj\quiz\withusers\header.php on line 29
PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL
resource in C:\prj\quiz\withusers\header.php on line 30
in all sorts of programs. Once I get this, I am not able to run a PHP that
uses those include files again. I suspect there's some sort of cacheing
going on here. this is driving me up the wall. One time, it took my
database down during a simple DROP TABLE operation. The database service
couldn't reconnect when I restarted it. shutting down & restarting the
database doesn't help.
any suggestions on how to proceed?
Re: mysql_connect() losing connections from cmd line
Not much to tell. Just one of those mindless errors. Can't believe I did
For one thing, I was including dbinc.php after using the functions. it's a
wonder it actually worked sometimes (bug in PHP?). I also had to move the
functions up before I used them.