validating username and password help

[Anon]

I am tring to make a login page that checks the username to password on mySQL. I was tring something like this but it was giving me an error.
<?php
mysql_connect ("something", "someone", "password");
mysql_select_db ("database");
$result = mysql_query ("SELECT password from tablename where username like '$username'");

if ($row = mysql_fetch_array($result))
if ($row["password"] == $pass)
do {
require ("page that I want to get to");
}

?>
<!-- $username and $ pass comes from the page that brought you here -->
if anyone can help that would be great.

[shanebauer]

I used something like this...

mysql_connect("something", "someone", "password");
mysql_select_db ("database");

$results = mysql_query("Select * from reporters where username = '$username' AND password = '$pass'");

if(!$results)
{
echo "Error";
return;
}

if(mysql_num_rows($results)>0)
{
// Successful login stuff here
}
else
{
// Bad login stuff here
}