I put it like this but it gives an error - Could not select database because No Database Selected <?php include "connect.php"; if (logIn($_POST['username'], $_POST['password']) ) header("Location: adminarea.html"); else die; function logIn($uid, $pwd) { // connect to the mysql server $link = mysql_connect($server, $db_user, $db_pass) or die ("Could not connect to mysql because ".mysql_error()); // select the database mysql_select_db($database) or die ("Could not select database because ".mysql_error()); $match = "select id from $table1 where username = '$uid' AND password = '$pwd'"; $qry = mysql_query($match) or die ("Could not match data because ". mysql_error()); $num_rows = mysql_num_rows($qry); if ($num_rows <= 0) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251"> </head> <body bgcolor="#000000" text="#FF0000" link="#FFFF00" vlink="#FFFF00" alink="#FFFF00"> <div align="center"> <?php echo "<p>wrong username or password !</p>"; echo "<a href=adminlogin.html>Go Back</a>"; return false; } else return true; } ?>