please help

natman3

i believe that my problem lies within getting the id from the user that is logged in and then comparing it with the collegiate.user_id in the mysql_query(); I am just not sure on how to do this because i think what its doing is looking at both tables and grabing the data that has identical 'id' which means its not getting the id from the currently logged in user. I think something like this might work but i am not sure how to implement it does anyone know?

$current_user = $_SERVER['id'];
			$result = mysql_query("SELECT count(*) FROM collegiate, users WHERE collegiate.user_id= '$current_user'") or die('Error : ' . mysql_error());

kburger

Don't you mean $SESSION['id'], not $SERVER['id'], or am I missing what you're trying to do?

Also, why use:

$result = mysql_query("SELECT count(*) FROM collegiate, users WHERE collegiate.user_id= '$current_user'") or die('Error : ' . mysql_error());

instead of

$result = mysql_query("SELECT count(*) FROM collegiate WHERE user_id= '$current_user'") or die('Error : ' . mysql_error());

You're only selecting one field from one table, so why include the second table in your query?

natman3

your right I ment $_SESSION['id'], as to why i use this:

			$result = mysql_query("SELECT count(*) FROM collegiate, users WHERE collegiate.user_id= '$current_user'") or die('Error : ' . mysql_error());

is because "FROM collegiate, users" allows me to select two tables and compare their fields. At least thats why i have seen happen. I could be wrong in my aproach though. You see the 'users' table has the users and the other table 'collegiate' has other information that the users are needing to view. SO my thought was to have the 'users' table id match the other table id and the it would allow the user to view their information but its not working

kburger

I can't imagine why you'd want to do that, but here's the query:

$result = mysql_query("SELECT count(*) FROM collegiate, users WHERE collegiate.user_id= '$current_user'" AND collegiate.user_id=users.user_id) or die('Error : ' . mysql_error());

natman3

well my reason is i am having a registration proccess where coaches can login and register their teams. And dependig on who is logged in i dont want them all to see everyone else from different colleges. So i am trying to get the data in this to only show to the appropriate user. its design i guess is alot like a cms