[RESOLVED] Variable Comparisons

[mdub2112]

Ok... I'm having a severe brain fart here.

I have a dbase that holds a table of usernames, pwords...., a table named prj_mgr_permissions with usernames (foreign key to users table), a table named user_permissions with the same... Different users are in each of those tables.

Now, when a user logs in and their username is within the prj_mgr_permissions table I want them to see one thing... All others will see something different.

Problem I'm having is that it seems that every username I log in as (in setup errr learning phase here) sees the same stuff.

Code I thought would work is

	$prj_mgr = $handle->query("select username from prj_mgr_permissions
	where username='{$_SESSION['auth_user']}'");

	if ($prj_mgr)
	{
	echo $_SESSION['auth_user'];
	echo 'You are a Project Manager';
	echo '[<a href="admin/logout.php">Logout</a>]';
	echo '<br />';
	}
	else
	{
	echo 'Sorry, you are only a poor user';
	echo '[<a href="admin/logout.php">Logout</a>]';
	echo '<br />';
	}

[laserlight]

Well, this depends on your database abstraction later. My guess is that the result of query() only is evaluated as false if the query failed, so $prj_mgr is always true even if there are no rows returned. What you want to do is check the number of rows returned (in fact, you could even just select that).

[mdub2112]

laserlight wrote:

Well, this depends on your database abstraction later. My guess is that the result of query() only is evaluated as false if the query failed, so $prj_mgr is always true even if there are no rows returned. What you want to do is check the number of rows returned (in fact, you could even just select that).

You mean something similar to

$prj_mgr = "select username from project_mgr_permissions
	where username='{$_SESSION['auth_user']}'";

$result = $handle->query($prj_mgr);

	if ($result->num_rows)

Added:
Guess that's what was meant as it did the trick!!
ThankYa

[laserlight]

Yes.

[bradgrafelman]

Don't forget to mark this thread resolved.