help please

natman3

I am not sure if its going to work. this is what my table 'collegiate' looks like:

id user_id first last year age gender last_change
1 1 John Erickson sophmore 22 m

2 2 billy boy junior 19 m

6 2 tobby adams freshmen 23

7 2 asd john senior 20 m

as you can see the user_id is tied to the users table 'id' for each registered user.

id login
1 millern

2 millerp

this code here:

$current_user = $_SESSION['id'];

		// matches the session 'id' of login user with the 'user_id' field from the talbe collegiate so that we can select the right content to be displayed
		$logged_id= mysql_query( "SELECT * FROM collegiate WHERE collegiate.user_id = '$current_user'"); 

		// gets the result from collegiate table, there one uniqueid tied to the rows. 
		$result = mysql_query("SELECT * FROM collegiate WHERE collegiate.user_id= '$logged_id'") or die('Error : ' . mysql_error());
		echo "$result";

i am trying to get the table users 'id' of the logged in person and match it to the table collegiate 'user_id' and from that have the correct information display for whoever is logged in by looking at the id.

I am having trouble accomplishing this.

bpat1434

First off, your queries return Resource Values not actual data. You need to put the values into an array first before you can use it.

Also, it looks like you're running the same SQL twice, why?

I think what you want is to JOIN the two tables based upon the id of the user.

$current_user = $_SESSION['id'];

        // matches the session 'id' of login user with the 'user_id' field from the talbe collegiate so that we can select the right content to be displayed
        $query = "SELECT * FROM
                users 
                JOIN collegiate 
                ON users.id = collegiate.user_id 
                WHERE a.id = '$current_user' 
                AND b.user_id = '$current_user'";
        $result = mysql_query($query);
        $row = mysql_fetch_array($row);
        foreach($row as $user)
        {
            echo $user;
        }

~Brett

natman3

Thanks for the help and suggestions

Weedpacket

I've pointed the copy of this post in the Coding section to the copy of this post in the Database section (http://www.phpbuilder.com/board/showthread.php?s=&threadid=10297663). Let's not waste brainpower trying to keep track of all these threads and who said what in them. Just stick to the one thread.