login code not working

[tycoon]

Hi all.....i'm trying to develope login page for my website..the code always seem to redirect to the failed login even though username and password are corect...can anybody please look trough my code

<?php
session_start();
header("Cache-control: private");

$username = $POST['username'];
$_SESSION['username'] = $username;
$password = $POST['password'];
$_SESSION['password'] = $password;

$db = @mysql_connect('localhost', 'root') or die('could not connect to mysql db, the server return the error:'.mysql_error());
mysql_select_db("timelinesys",$db) or die('could not connect to mysql db, the server return the error:'.mysql_error());
$query = "select * from user where username='$username' and password='$password'";
$sql = mysql_query($query) or die(mysql_error());
$count = mysql_num_rows($sql);

if ($count == 1)
{
header('Location: menu.php'); 
}
else
{
header('Location: loginfailed.php'); 
}
?>[/PHPNET]

[dyntryx]

At first glance, shouldn't you be using $POST['username'] and $POST['password'] rather than $POST['username'] and $POST['password']?

Take note there is an underscore after the $.

[kburger]

Looks OK to me. I'd suggest putting in some debugging echo statements to see if the query you're actually executing is the query you think you're executing. If it still looks OK, run those queries using phpMyAdmin or the MySQL monitor at the command line.

edit: good catch dyntryx. didn't see that.

[tycoon]

Thank you everybody for guidence and help