mysql_connect() losing connections from cmd line

[Jim Michaels]

I am running windows XP and PHP 5.1.2 with the MySQL extension enabled in
php.ini.
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
C:\prj\quiz\wit husers>php taaddtt2grp.php
PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resourc
e in C:\prj\quiz\wit husers\header.p hp on line 28
PHP Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL
result
resource in C:\prj\quiz\wit husers\header.p hp on line 29
PHP Warning: mysql_free_resu lt(): supplied argument is not a valid MySQL
result
resource in C:\prj\quiz\wit husers\header.p hp 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?

[Jim Michaels]

found the source of the problem in my header file.
Gotta stop posting like this.
Still, I think it's odd that PHP was able to take out the MySQL server once.

"Jim Michaels" <NO************ ***@yahoo.com> wrote in message
news:Ts******** *************** *******@comcast .com...

I am running windows XP and PHP 5.1.2 with the MySQL extension enabled in
php.ini.
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
C:\prj\quiz\wit husers>php taaddtt2grp.php
PHP Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resourc
e in C:\prj\quiz\wit husers\header.p hp on line 28
PHP Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL
result
resource in C:\prj\quiz\wit husers\header.p hp on line 29
PHP Warning: mysql_free_resu lt(): supplied argument is not a valid MySQL
result
resource in C:\prj\quiz\wit husers\header.p hp 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?

[Raqueeb Hassan]

> found the source of the problem in my header file.

Thanks for posting back with the troubled area. It's a good sign. You
might point out the details for others.

Thanks.
--
Raqueeb Hassan
Bangladesh

[Jim Michaels]

"Raqueeb Hassan" <wi*******@gmai l.com> wrote in message
news:11******** **************@ t31g2000cwb.goo glegroups.com.. .

found the source of the problem in my header file.

Thanks for posting back with the troubled area. It's a good sign. You
might point out the details for others.

Thanks.
--
Raqueeb Hassan
Bangladesh

Not much to tell. Just one of those mindless errors. Can't believe I did
it.
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.