Join and tables

frankobi

Hi All,

I need some help with accessing data from three tables, using a login screen. I have joined the tables, but when a user tries to log in to access his/her record, the system gives the following error message: “Sorry, could not log you in. Wrong login information.”

I presented this problem before, and I was advised to check my data and my SQL logic and then test the query against the same set of data. I have tested the query against the data. The query works, as long as I do not include a join of any sort. Please could someone help me pinpoint the problem? Find my codes below.

Thank you.

***Login.php*****

<?php
session_start();
// dBase file
include "dbConfig2.inc";

$rs = mysql_select_db("lhsnycne_schedule",$dbh) 
	or die("error connecting to the database");

	if ($_GET["op"] == "login")
		{
		if (!$_POST["studentid"] || !$_POST["password"])
			{
			die("You need to supply a studentid and password.");
			}

		// Create query
		//$q = "SELECT * FROM `student` "

$q="select TEACHERCLASS.period, SCHEDULE2.classcode, TEACHERCLASS.room,
TEACHERCLASS.teacherlname, TEACHERCLASS.days, STUDENT2.studentid
FROM
TEACHERCLASS, STUDENT2, SCHEDULE2
WHERE
TEACHERCLASS.classcode = SCHEDULE2.classcode AND
STUDENT2.studentid = SCHEDULE2.studentid

	order by period" 

			."WHERE `studentid`='".$_POST["studentid"]."' "
			."AND `password`=PASSWORD('".$_POST["password"]."') "
			."LIMIT 1";
		// Run query
		$r = mysql_query($q);

		if ( $obj = @mysql_fetch_object($r) )
			{
			// Login O.K., create session variables
			$_SESSION["valid_period"] = $obj->period;
			$_SESSION["valid_classcode"] = $obj->classcode;
			$_SESSION["valid_id"] = $_POST["studentid"];
			$_SESSION["valid_room"] = $obj->room;
			$_SESSION["valid_teacherlname"] = $obj->teacherlname;
			$_SESSION["valid_days"] = $obj->days;
			$_SESSION["valid_time"] = time();

			// Redirect to member page
			Header("Location: members3.php");
			}
		else
			{
			// Login not successful
			die("Sorry, could not log you in. Wrong login information.");
			}
	}
	else
		{
		echo "<form action=\"?op=login\" method=\"POST\">";
		echo "Studentid: <input name=\"studentid\" size=\"15\"><br />";
		echo "Password: <input type=\"password\" name=\"password\" size=\"8\"><br />";
		echo "<input type=\"submit\" value=\"Login\">";
		echo "</form>";
		}
	?>

=============================
***members3.php********

<?php
session_start();

if (!$_SESSION["valid_id"])
{
// User not logged in, redirect to login page
Header("Location: login3.php");
}

// Display Member-only stuff
// ...
// ...
// ...

// Display Member information
echo "User ID: " . $SESSION["valid_id"];
echo "Period: " . $SESSION["period"];
echo "Classcode: " . $SESSION["classcode"];
echo "Room: " . $SESSION["room"];
echo "Teacher: " . $SESSION["teacherlname"];
echo "Days: " . $SESSION["days"];
echo "Logged in: " . date("m/d/Y", $_SESSION["valid_time"]);

// Display logout link
echo "<a href=\"logout3.php\">Click here to logout!</a>";
?>

=========================

nemonoman

I'm the guy that answered you before. If your query isn't throwing an error, it 'works', and the problem is with your data; or rather that the answer you are expecting is not supported by the data you are using.

In point of fact, your query is probably throwing an error:

TUDENT2.studentid = SCHEDULE2.studentid

order by period"<<<<

."WHERE studentid='".$POST["studentid"]."' "
."AND password=PASSWORD('".$POST["password"]."') "

Order by shoule be the last or next to the last line of the query:
SELECT
FROM
[WHERE]
[GROUP BY ]
[ORDER BY]
[LIMIT]