User Login problem

[Undrium]

I'm trying to make an extremely simple login site. It'll just compare the username and password if they are correct. I've put in an echo to see if it's working properly, though now it seems like I've no idea what I'm doing. The echo message won't appear.

<?php

if (!isset($_POST['username2'])){ 

$result = @mysql_query('SELECT id, username, password FROM members');
$username2 = $_POST['username2'];
$password2 = $_POST['password2'];
	if (!$result) {
		exit('<p>Error performing query: '. 
		myqls_error() . '</p>');
		}

while ($row = mysql_fetch_array($result)){


if ($username2 == $username && md5($password2) == $password) { 

echo '<p>The user/pass was correct!</p>'; 
} 
} 
}
?>

I am connecting to the database earlier in the code. This is the vital code, I now wonder what's wrong with it. Can you see any error with it that I cannot? Thanks. 🙂

[thorpe]

its allot simpler than you making it.

<?php 
if (isset($_POST['username2']) && isset($_POST['username2'])){ 
    $username2 = $_POST['username2']; 
    $password2 = $_POST['password2'];
    $result = @mysql_query("SELECT id, username, password FROM members WHERE username = '$username2' && password = '$password2'"); 
    if ($result) {
        if (mysql_num_rows($result) > 0) {
            echo '<p>The user/pass was correct!</p>';
        }
    }
}
?>

[Undrium]

Thanks alot, Thorpe! 🙂

[Aybabtu]

Make sure to change the 2nd isset($POST['username2'] to isset($POST['password2']

Aybabtu.