Query\IF Statement Help

[mdub2112]

Ok, I have a db with tables user_permissions and prj_mgr_permissions.
Both tables have a column username

I am trying to do a query against the prj_mgr_permissions table where
if the session['auth_user'] = prj_mgr_permissions.username then
echo this
else
echo that

However; I simply, cannot get this to work.

How I currently have it set up

  $rights_sql = "select username from prj_mgr_permissions
  where prj_mgr_permissions.username = '$_SESSION['auth_user']}'";
  if ($rights_result = query($handle, $rights_sql))
  {
  while ($prjmgr = fetch_assoc($rights_result))
  {
  echo 'Hiya';
  }
  echo 'You passed';
  }

[stolzyboy]

$rights_sql = "select username from prj_mgr_permissions 
  where prj_mgr_permissions.username = '$_SESSION['auth_user']}'"; 

$rights_result = query($handle, $rights_sql) //assuming this runs your query in the function with mysql_query
  if (mysql_num_rows($rights_result) != 0)
  { 
  echo "you have rights"; 
  } 
else
{
  echo "you have NO rights"; 
  }

[Sangre]

$a = 1
$b = 2

If ($a = $b) <--- this will be TRUE
because it makes first $a and $b the same, then gives only false, when it returned an errormessage. basicly you say here: Make $a and $b the same, if you succeeded, then continue.

you need this:
If ($a == $b) <--- FALSE

$a = true
$b = 1

if ($a == $b) <--- TRUE, (true and 1 are the same)
if ($a === $b) <--- FALSE (true and 1 are not the same)

if you want NOT true, then use
!= in stead of ==

and !== in stead of ===

So basicly:
= means 'Make the same'
== means 'If they are the same'
=== means 'If the are the same AND the same type' (numeric, bolean, alpha, etc)
!= means 'Not the same'
!== means 'Not the same OR not the same type'

There are a few more, if you like them, just ask 🙂

[mdub2112]

Ended up goin' with

$result = $handle->query("select username from prj_mgr_permissions
                              where username='{$_SESSION['auth_user']}'");
    if (!$result)
    {
  echo 'You have no rights';
    }
    if ($result->num_rows>0)
    {
echo 'You have rights';
    }
    else 
    {
echo 'You have no rights';
    }

Not sure why I couldn't get your code to work stolzyboy, especially with the above being so close, either way...I'm workin' now.
Thanks All

[stolzyboy]

i'm sure it had something to do with your query code being in a function and me not being able to see the function and how it was processed, essentially, you did the same thing, tho, i'd structure it differently... since the way i'm seeing it, there if they have no rights, they'll probably get two messages telling them of no rights

stolzyboy