No matter what I try, I keep getting Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ___
I tried array also, but here's the code for the login page.
About 23 lines down.
Also, I'm new to PHP, as in, today new.
/* Start session */
if($startSession == TRUE){ session_start();}
/* Config file */
include('config.php');
/* Check for submition */
if($_POST['submitID'] == 1){
/* Connect to database */
if($connectDatabase == TRUE){$action=TRUE;include('connect.php');}
/* sanitize and check info */
$userName = mysql_real_escape_string($_POST['userName'],$dbc);
$password = mysql_real_escape_string($_POST['password'],$dbc);
if($userName == NULL) { $message = 'Please enter username.';}
if($message == NULL && $password == NULL){ $message = 'Please enter password.';}
if($message == NULL)
{
$userQuery = mysql_fetch_row (mysql_query("SELECT COUNT(*) FROM " . $tableName .
" WHERE `" . $userNameField . "`='$userName' AND `" . $userPasswordField . "`='$password'"));
/* If usercount is more than 0 -> ok */
if($userQuery[0] > 0){
/* Disconnect from database */
if($connectDatabase == TRUE){$action=FALSE;include('connect.php');}
$_SESSION['isLoged'] = 'yes';
$_SESSION['userName'] = $userName;
/* add cookies ?*/
/* expire in 1 hour */
if($useCookies == TRUE)
{
setcookie("isLoged", 'yes', time()+logedInFor, "/", ".$domainName", 1);
setcookie("userName", $userName, time()+logedInFor, "/", ".$domainName", 1);
}
/* Redirect to login page */
header("Location: $loginPage");
exit();
} else {
$message = 'Invalid username and/or password!';
}
}
/* Disconnect from database */
if($connectDatabase == TRUE){$action=FALSE;include('connect.php');}
}
?>