Hi

I have a problem, this is my code:

$db = new mysqli("localhost", "root", "", "blah");

$result1 = $db->query("select * from c_register where email = '$eml' and password = '$pass'");

if($result1->fetch_array())

{

    $auth->createSession();

    $_SESSION['user'] = 'client';

    promptUser("You have successfully logged in!!!","index.php");

}

$db = new mysqli("localhost", "root", "", "blah");

$result2 = $db->query("select * from b_register where email = '$eml' and password = '$pass'"); if($result2->fetch_array())

{

     $auth->createSession();

     $_SESSION['user'] = 'business';

     promptUser("You have successfully logged in!!!","index.php");

} $db = new mysqli("localhost", "root", "", "blah");

$result3 = $db->query("select * from g_register where email = '$eml' and password = '$pass'"); if($result3->fetch_array())

{

    $auth->createSession();

    $_SESSION['user'] = 'employee';

    promptUser("You have successfully logged in!!!","index.php");

}

$db = new mysqli("localhost", "root", "", "blah");

$result4 = $db->query("select * from k_register where email = '$eml' and password = '$pass'"); if($result4->fetch_array())

{

    $auth->createSession();

    $_SESSION['user'] = 'super';

    promptUser("You have successfully logged in!!!","index.php");

} else

{

    promptUser("Username/Password do not match.  Please try again!!!","");

}

Funny enough this code works, but I no that I went about it the wrong way. I am new with php and mysql, so please help. I also tried e.gresult4->free(); for all the variable that save the data, and I got this error: Fatal error: Call to a member function free() on a non-object in...