Autentication from a MYSQL table

[Gregg]

Does anyone know how I can have a sign in page which searches a table on the MYSQL database for a matching name and password. I have written a script with a static authentication system, but I would like to extend it's capabilities.

Thanks

Greg

[Kudose]

mysql_connect('localhost', 'dbusername', 'dbpassword', 'dbtable');

$query = "SELECT * FROM tablename WHERE username='$username' AND password='$password');

$result = mysql_query($query);

$rows = mysql_query($result);

if ($rows = "1") {

 Authenitcated 

} else {

Invalid
}

[Gregg]

Thanks for the help. I could not find an example anywhere