$username = $_REQUEST['your_text_field_name_here'];
$password = $_REQUEST['your_pass_field_name_here'];
$query = mysql_query('SELECT user_name,pass_word FROM YOUR_TABLE WHERE user_name = $username AND password=$password ')
if ($_POST[ $username])
{
if ($_POST[$password])
{
if( $username = user_name && $password= pass_word )
{
echo "login success";
}
else
{
echo "login failed";
}
else
{
echo "you must enter password";
}
}
else
{
echo "login Failed error";
}