Best way to login and open 'home'

[imnsi]

Alright, I got the login to work. Now I just need to know the best way to open the specific htm based upon the users login.

if ($checkpassword == $password1){
echo "Please <A href=...members/". $Email .".htm>CLICK HERE</a> to proceed.";
}

else{

echo "Sorry Invalid Password/Login, Please <A href=...members/login.htm>TRY AGAIN</a>.";

}

[imnsi]

WAIT NO.. I spoke too soon, the script I have only checks to see if the password is right, not worrying about the user name.. whats going wrong here and how can i fix it?

$link = mysql_connect ($host, $user, $pass);


mysql_select_db($db, $link) or die ("Couldn't open $db!");

// the db query
$q = "SELECT Email, Password FROM `contacts`";

//$results = mysql_db_query ($db, $q, $link); 

$results = mysql_query($q) or die (mysql_error()); 

// fetching the results

$row = mysql_fetch_array($results);

$checkpassword = $row["Password"];
$email1 = $row["Email"];


mysql_close();


if ($checkpassword == $password1){
echo "pw correct";