[DrScion]

My apologies, I miread one of the post I searched.

I have fixed my problem, and I will post the correct code for future reference...

PHP Code:

mysql_select_db($database_connect, $connect); 
$query_get_user = sprintf("SELECT * FROM vb_user WHERE username='%s'", $HTTP_POST_VARS['username']); 
$get_user = mysql_query($query_get_user, $connect) or die(mysql_error()); 
$row_get_user = mysql_fetch_assoc($get_user); 
$totalRows_get_user = mysql_num_rows($get_user); 

$password = md5(md5($HTTP_POST_VARS['password'])  $row_get_user['salt']); 

mysql_select_db($database_connect, $connect); 
$query_get_password = sprintf("SELECT * FROM vb_user WHERE password='%s'", $password); 
$get_password = mysql_query($query_get_password, $connect) or die(mysql_error()); 
$row_get_password = mysql_fetch_assoc($get_password); 
$totalRows_get_password = mysql_num_rows($get_password); 

if($totalRows_get_password == 0) { 
die('Password Error'); 
}