Untitled

<html>
<body>
<?php
$host="127.0.0.1";
$username="root";
$password="root";
$db_name="freelobby";
$tbl_name="login";

mysql_connect("$host","$username","$password")ordie("cannot connect");
mysql_select_db("$db_name")ordie("cannot select DB");

$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($count==1){
session_register("myusername");
session_register("mypassword");
header("location:login_success.php");
}
else{
echo "Wrong username or password";
}


?>
</html>
</body>