login

<?php
include("db.php");
session_start();
if($_SERVER["REQUEST_METHOD"] == "POST")
{
// username and password sent from Form
$username=mysql_real_escape_string($_POST['username']);
$password=mysql_real_escape_string($_POST['password']);
$password=md5($password); // Encrypted Password
$sql="SELECT id FROM users WHERE username='$username' and passcode='$password'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);
$active=$row['active'];
$count=mysql_num_rows($result);

// If result matched $username and $password, table row must be 1 row
if($count==1)
{

$_SESSION['login_user']=$myusername;
    session_register("myusername");
header("location: welcome.php");
}
else
{
$error="Your Login Name or Password is invalid";
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Jon Holland - About Me</title>
<link href="Style-Sheet.css" rel="stylesheet" type="text/css" />

</head>
<body>
    <div id="page-wrap">
        <div id="inside">

            <div id="header">
                <h1>Jon Holland</h1>
<div id="menu">
            <ul id="navlist_ul">
                <li class="first"><a href="1-Main.html">About Me</a></li>
                <li><a href="2-Gaming.html">Gaming</a></li>
                <li><a href="3-FilmsBooks.html">Films & Books</a></li>
                <li><a href="4-Gallery.html">Gallery</a></li>
                <li><a href="5-ThingsIFindGoddamnHilarious.html">Things I Find Godamn Hilarious</a></li>
                <li><a href="membersonly.php">membersonly!</a>
            </ul>
        </div>
                    </div>
            </div>
      <p>            <table width="250
            " border="0" align="center" cellpadding="3" cellspacing="3" bgcolor="" id="register">
<tr>
<form name="login" method="post" action="login.php">
<td>
<table width="95%" border="0" cellpadding="3" cellspacing="3" bgcolor="#666666">
<tr>
<td colspan="3"><strong>Member Login </strong></td>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="username" type="text"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="password" type="password"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td><input type="submit"value="Login"> <a href="Register.html">Register</a></td>
</tr>
</table>
</td>
</form>
</tr>
</table></p>
      <div style="clear: both;"></div>

            <div id="footer">
                <p>Footer stuff.</p>
            </div>

        </div>

        <div style="clear: both;"></div>

    </div>
</body>
</html>