[SOLVED] Warning: mysql_close(): supplied argument......

[plutomed]

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/plutomed/public_html/new/functions.php on line 20

 

Here is my function that connects:

 

function connect_db($user, $pass, $db)
{
$con = mysql_connect("localhost", $user, $pass) or die(mysql_error());
$db_selected = mysql_select_db($db) or die(mysql_error());
}

 

And the query function:

 

function referer()
{
connect_db("uname", "pass", "db");

//query

mysql_close($con);
}

[NArc0t1c]

What exactly is " this " ?

Try putting the function as an variable.

Explanation:

function referer()
{
$connect = connect_db("uname", "pass", "db");

//query

mysql_close($connect);
}

[plutomed]

Nope that didn't work and all I am doing is changing my site a bit

[chocopi]

is it because you have $con in a different function and it isnt carried over to the other function unless you set it to a gobal.

 

this is just a guess seeing as I don't like functions so I don't use them

 

~ Chocopi

 

 

[plutomed]

How do ya set it to global?

[cooldude832]

why close it if you might run more queries on the page?

[plutomed]

Good point I guess I'm just used to doing it

[cooldude832]

good idea is on the end of a page make a function called endofpage and basicaly close up everything in it.

[plutomed]

Brill. idea thanx

[plutomed]

I was going to create the function end(); but I noticed it is already used is there anyway I could use it still?

[plutomed]

Can you?

[teng84]

you can you use it as many times you want but yo cant create as many times you want

[plutomed]

end(); is a predefined function, can I still create my one function called end like this:

 

function end()

{

//code

}

[teng84]

i told you if there is an existing function user or predefine u cant recreate it

[plutomed]

Oh ok thanx

[teng84]