MySQL

Inner Joins

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2008

Posts: 10

Reputation: theo19 is an unknown quantity at this point

Solved Threads: 0

theo19

Offline

Newbie Poster

Inner Joins

Oct 13th, 2009

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<?php
 
$host='localhost';
	$user='root';
	$pass='';
 
	//establish database connection
	$conn=mysql_connect($host,$user,$pass) OR die('Unable to connect');
 
	//SELECT database for USE
    mysql_select_db('acumenchain') OR die('Unable to select database!');
 
 
	    $query2 = "SELECT tblclasslist.studentNo 
					FROM acumenchain.tblclasslist 
					JOIN acumenchain.tblregistration 
					ON tblclasslist.studentNo = tblclasslist.studentNo";
 
		$result = mysql_query($query2) OR die('Unable to execute Query' . mysql_error());
        $num = mysql_num_rows($result);
 
 
	//close connection
    mysql_close($conn);
 
?>
<?php

$host='localhost';
	$user='root';
	$pass='';
	
	//establish database connection
	$conn=mysql_connect($host,$user,$pass) or die('Unable to connect');
	
	//select database for use
    mysql_select_db('acumenchain') or die('Unable to select database!');
	

	    $query2 = "SELECT tblclasslist.studentNo 
					FROM acumenchain.tblclasslist 
					JOIN acumenchain.tblregistration 
					ON tblclasslist.studentNo = tblclasslist.studentNo";
					
		$result = mysql_query($query2) or die('Unable to execute Query' . mysql_error());
        $num = mysql_num_rows($result);
				

	//close connection
    mysql_close($conn);
	
?>

database name : acumenchain
Under my tblclasslist is studentNo (primary key).
Under my tblregistration is studentNo (primary key) and pword
Under my tbllogin is studentNo (primary key) and pword.

Objectives:

I want that only students who are registered in the tblclasslist can register on tblregistration.
I want that only who are registered can log-in to my site using his/her studentNo and pword.

Thanks

•

Join Date: Aug 2007

Posts: 799

Reputation: darkagn has a spectacular aura about

Solved Threads: 110

darkagn

Offline

Master Poster

Oct 14th, 2009

Try this:

Help with Code Tags

php Syntax (Toggle Plain Text)

$query2 = "SELECT tblclasslist.studentNo FROM acumenchain.tblclasslist JOIN acumenchain.tblregistration ON tblclasslist.studentNo = tblregistration.studentNo JOIN acumenchain.tbllogin ON tblclasslist.studentNo = tbllogin.studentNo AND tbllogin.studentNo = tblregistration.studentNo";

Does this give the desired result?

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.