PHP Warning: mysql_close(): supplied argument is not a valid

[Gary_Kambic]

$user="user";
$password="pass";
$database="db";
$link = mysql_connect("mysqldb",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");

mysql_close($link);

PHP Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /hermes/data11/b364/hintsforhomes/protection.php on line 158

According to the manual the way I have this written should work. Now sure why I'm receiving this error.

Has anyone else experienced this error? Gary

[HalfaBee]

You probably don't have the correct server name in the mysql_connect()

Halfabee

[Gary_Kambic]

Hostname: mysqldb

Directly from my web server host site.

Seems like that would be the problem but they match perfectly.

[HalfaBee]

Put or die( mysql_error() ) after the mysql_connect() and see what comes out.

HalfaBee

[Gary_Kambic]

$host = "mysqldb";
$link = mysql_connect($host,$user,$password) or die ("Can't connect because ".mysql_error());
@mysql_select_db($database) or die ("Can't connect because ".mysql_error());

PHP Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /hermes/data11/b364/hintsforhomes/protection.php on line 159

[HalfaBee]

Ok, I don't know.

Just don't use mysql_close() 🙂
It is not needed as when the script ends the link is closed.

HalfaBee

[Gary_Kambic]

Very bizarre. It of course works now, no error. Is their a downside to not having the close statement?

g

[HalfaBee]

You really only need it if you use mysql_pconnect() for a persistant database connection.

HalfaBee

[Gary_Kambic]

OK. Hey thanks for all your help.