Login PHP, Quick Question?

[Chris McGee]

When I put my username and password in the fields and then submit I get the fallowing error...

 

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/purseati/public_html/Connections/users.php on line 58

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/purseati/public_html/Connections/users.php on line 63

 

Does anyone know what to do?

[trq]

Post your code!

[Chris McGee]

<?php require_once('Connections/users.php'); ?>

<?php

$host="localhost";

$user="purseati_XJ5014";

$pass="mcgee87";

$db="purseati_userlogin";

 

$connection = mysql_connect($host,$user,$pass)or die ('Unable to connect');

mysql_select_db($db) or die ('Unable to select DB');?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

 

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

?>

<?php

// *** Validate request to login to this site.

if (!isset($_SESSION)) {

  session_start();

}

 

$loginFormAction = $_SERVER['PHP_SELF'];

if (isset($_GET['accesscheck'])) {

  $_SESSION['PrevUrl'] = $_GET['accesscheck'];

}

 

if (isset($_POST['usernameText'])) {

  $loginUsername=$_POST['usernameText'];

  $password=$_POST['passwordText'];

  $MM_fldUserAuthorization = "";

  $MM_redirectLoginSuccess = "contact.html";

  $MM_redirectLoginFailed = "home.html";

  $MM_redirecttoReferrer = false;

  mysql_select_db($database_users, $users);

 

  $LoginRS__query=sprintf("SELECT username, password FROM users WHERE username=%s AND password=%s",

    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text"));

 

  $LoginRS = mysql_query($LoginRS__query, $users) or die(mysql_error());

  $loginFoundUser = mysql_num_rows($LoginRS);

  if ($loginFoundUser) {

    $loginStrGroup = "";

   

    //declare two session variables and assign them

    $_SESSION['MM_Username'] = $loginUsername;

    $_SESSION['MM_UserGroup'] = $loginStrGroup;      

 

    if (isset($_SESSION['PrevUrl']) && false) {

      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];

    }

    header("Location: " . $MM_redirectLoginSuccess );

  }

  else {

    header("Location: ". $MM_redirectLoginFailed );

  }

}

?>

[aqlx86]

may be you dont have a valid mysql connection resource.. double check host,username,password, db