Fetch data from DB

[jjmmrg]

No i tried the following
<pre>

Code:

<?php
  $sql= "select name from permissions where id=users.permissions";
  $rslt = $db->query($sql);
  foreach($rslt as $newArray){
  $roleName = $newArray['name'];
  echo "$roleName";
}

</pre>


It results nothing . Just blank . I am really really worried without knowing where i am doing mistake