Can't login!

[steelmanronald06]

Here are my lines. (note that you should not add the <?php and ?> to those lines..that is added for the sake of color :)

Lines 1 - 13
[code]
<?php

//Require the headers
require_once('../includes/headers.php');

//Require the db.php file
require_once('../includes/db.php');

//Require functions.php
require_once('../includes/functions.php');

//Require top layout
require_once('../includes/top.php');
?>
[/code]

lines 44 - 98

[code]
<?php
//Convert the password to md5
$password = md5($password);

//Run the validation query
$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' AND activated='1'");

//Get the result
$login_check = mysql_num_rows($sql);

//See if the login information was correct
if($login_check > 0){
while($row = mysql_fetch_array($sql)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}

// Register some session variables!
        session_register('userid');
        $_SESSION['first_name'] = $userid;
session_register('first_name');
$_SESSION['first_name'] = $first_name;
session_register('last_name');
$_SESSION['last_name'] = $last_name;
        session_register('username');
        $_SESSION['username'] = $username;
session_register('email_address');
$_SESSION['email_address'] = $email_address;
session_register('special_user');
$_SESSION['user_level'] = $user_level;
session_register('ban');
$_SESSION['ban'] = $ban;

//Update their last logon time
mysql_query("UPDATE users SET last_login=now() WHERE userid='$userid'");

//Show the bottom layout
require_once('../includes/bot.php');

//Output Buffering
ob_start();

//Reload to the success case
header("Location: /lampgeekz/users/log.php?cmd=success");

ob_flush();

}

}else{

echo "You were not logged in! Your username and/or password were incorrect. Please try again!";
echo $username;
echo $password;

}
?>
[/code]

when I submit the form to it (this is all one switch which should work) i get this from the variables:

[quote]
$username echos as: netgeek
$password echos as: 6a19bbb52d8327f9149be17eaf420c01
[/quote]

It matches the database, i checked it :), but I still get this:

[quote]
You were not logged in! Your username and/or password were incorrect. Please try again!
[/quote]

now why would my custom error be thrown?  Is there something wrong with the mysql query that is making it where it does query the database right?  :'(

[steelmanronald06]

btw, headers.php contains session_start :)