I figured it out last night:
PHP Code:
$sql = "SELECT username, password, salt FROM user WHERE username = '$xUsername' LIMIT 0,1";
$query = mysql_query($sql);
$records = mysql_num_rows($query);
while ($result = mysql_fetch_array($query)) {
extract ($result);
if ($records == '1') {
$md5password = md5(md5($xPassword). $salt);
if ($password == $md5password) {
echo "Login: Valid";
} else {
echo "Login: Invalid";
}}
if ($records == '0') {
echo "Invalid Username<br>";
}
That worked out perfectly. I didn't know about the 'salt' variable.