Okay, from everything I have read this code should check the username & password against my table, but for some reason it's going to the next page without regardless of the user input

Please help!!

<?php

include("misc.inc");

  $connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
  $db = mysql_select_db($database,$connection)
       or die ("Couldn't select database");
session_id()


$Username= 'Username';
$Password= 'Password';

$query = "SELECT * FROM Recruiter
	WHERE 'Username'='$Username' AND 'Password'='$Password'";

	$results = mysql_query or die('error making query');

 IF ($results = 1)

    { header("Location:Recruiters.php");
}
	ELSE
     header("Location:LoginForm.php");





?>

THANK YOU!!!

I didn't look at all of your code, but one error I spotted right away was this:

IF ($results = 1)

It basically says, "If I am able to assign the value 1 to the variable $results..."

Try:

IF ($results == 1)

...for checking if $results equals 1.

Mike

Thanks Mike, I changed that, but it still isn't checking it.

$query = "SELECT * FROM Recruiter
WHERE 'Username'='$Username' AND 'Password'='$Password'";

$results = mysql_query or die('error making query');

IF ($results = 1)

{ header("Location:Recruiters.php");
}
ELSE
header("Location:LoginForm.php");

okay try this instead

PHP Code:

$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);

if($login_check > 0){
    while($row = mysql_fetch_array($sql)){
        /*  session_start();
      //  use edit the following if you want sessions 
       $_SESSION['first_name'] = $row['fname'];
       $_SESSION['last_name'] = $row['lname'];
       $_SESSION['email_address'] = $row['email'];
       $_SESSION['access'] = $row['access'];
       $_SESSION['username'] = $row['username'];
       $session = session_id();
        */
        header("Location: Recruiters.php"); 


I based it off of my working logon script

KML9870, I don't know if I'm right in saying this, but it looks like your section of code

PHP Code:

$results = mysql_query or die('error making query'); 


is causing the problem

$results = mysql_query($query) or die('error making query');


but that is not all...I think you need to use mysql_num_rows to assign the numeric value to your variable.

$rownumber = mysql_num_rows($query);

now you can check whether $rownumber == 1

oops I made a small error

change

$rownumber = mysql_num_rows($query);

to

$rownumber = mysql_num_rows($results);