[SOLVED] detecting a mysql connection

[M.O.S. Studios]

Hey,

I'm making a function that detects if a user is logged in or not,

in one part of this function I need to connect to the "mysql" db. I wanted to know if there is a code or builtin function of php that auto detects if a connection to the "mysql" db is already made or not???

 

 

thanks in advance

[M.O.S. Studios]

btw i tried using the mysql_thread_id() and mysql_ping(), they work fine, how ever when no connection is found it creats a E_WARNING, that is a problem

[RussellReal]

function error_function() {

  // this will trigger if mysql_connect fails..

}

mysql_connect(...) or error_function();

 

you could also do..

 

if (mysql_connect(...)) {

} else {

  // failure

}

[M.O.S. Studios]

thanks but that's not what I'm looking for,

i don't need to know if the connection was succsessful, i need to know if there is already a connection made.

basically i want to avoid connecting twice.

[M.O.S. Studios]

figured it out,

 

this is what i did

<?php
function logedin()
{
if(@mysql_ping()===FALSE)
{
	include("admin/common/link.php");
	$linked=TRUE;
}

//  ... the log in verifier //

if($linked==TRUE)
{
	mysql_close($link);
}
}
?>