[SOLVED] User Log On Form

[Vitamin]

I have a forum on one page and I'm passing though 2 variables.  Username and Password.

 

<?php
$link = mysql_connect('localhost','root','password')
or die("Failed Logon");
mysql_select_db("users");
$username = $_POST['username'];
$password = $_POST['password'];
if($username=="" || $password=="")
{
die("Please do not leave the username / password field blank!");
}
$result = mysql_query("SELECT * FROM users WHERE
username=$username AND password=$password");
$number = mysql_num_rows($result);
if($number==0)
{
die("Your login details are not right. Please click the back button
and correct them.");
}
echo $password ;
echo $username ;
?>

 

I know every thing works up to the point where it reaches the select statement then something is going wrong.  I have all the correct information in the database and I've tried different users, but none are working.

 

Any help would be appreciated.  I'm new to php, but have done simular things with CF and Access.

[Vitamin]

Sigh... got it.  My database is not users thats my table

 

username='$username' AND password='$password'");

And needed to add tick marks.

 

[mikelmao]

<?php
$link = mysql_connect('localhost','root','password')
or die("Failed Logon");
mysql_select_db("users");
$username = $_POST['username'];
$password = $_POST['password'];
if($username=="" || $password=="")
{
die("Please do not leave the username / password field blank!");
}
$result = mysql_query("SELECT * FROM users WHERE
username=". $username ." AND password=". $password");
$number = mysql_num_rows($result);
if($number==0)
{
die("Your login details are not right. Please click the back button
and correct them.");
}
echo $password ;
echo $username ;
?>

That should do it