Can't figure it out.

[ATLien]

here is a function I made:

 function login($username, $password)
{
	$password = md5($password);

$conn = db_connect;
if (!$conn)
	return false;

$result = mysql_query("Select * from sv_users where user_name='$username' and user_password='$password'") or die ("Mysql error: " . mysql_error());

if (!$result)
	return false;

if (mysql_num_rows($result)>0)
	return true;
else
	return false;
}

Here is the db_connect function:

function db_connect(){
	$result  = mysql_connect ("localhost", "students_student", "*******") or die ('I cannot connect to the database because: ' . mysql_error());
	mysql_select_db ("students_college"); 
	if (!$result)
		return false;
		return $result;}

Someone please help me out. I am getting this error:

Mysql error: No Database Selected

I know all my database settings are right because another form that uses that db_connect works fine. HELP!!!!!!

[skiing900]

use this

mysql_select_db('databasename');

switch database name with the one you are using off your server

[stolzyboy]

maybe

$conn = db_connect;

needs to be

$conn = db_connect();

[stolzyboy]

Originally posted by skiing900
use this

mysql_select_db('databasename');

switch database name with the one you are using off your server [/B]

that was already in there

mysql_select_db ("students_college");

[skiing900]

disguard mine, his is right, it's the function syntax

[ATLien]

Thanks, That was it.