Social Engine 4-Get values from a table

//gets a table called engine4_authorization_permissions

$permissionTable=Engine_Api_()->getDbTable('permissions','authorization');

$permissionSelect=$permissionTable->select()->where('level_id'=?,$userlevel)->where('type'=>'usercommit');

$fetchdata=$permissionTable->fetchrow($permissionSelect);

$fetchdatas=$permissionTable->fetchrows($permissionSelect);
//To get attribute from row

echo $fetchdata->attribute_name

foreach($fetchdatas as $fetchdata)
{
     echo $fetchdata->attribute_name;
}

Social Engine 4-Get avtar of user

$user_id=Engine_Api::()_->user->getviewer->getIdentity();

$userinfo=Engine_Api::_()->user()->getUser($user_id);

$photo_id=$user_info['photo_id'];


//Fetches table Engine4_storage_files

$filesTable=Engine_APi::_()->getDbtable('files','storage');

$adapter=Engine_Db_Table::getDefaultAdapter();

$filesTableName=$filesTable->info('name');

$query=Engine_Db_Table::getDefaultAdapter()->select("storage_path")->from($statsTableName)->where("field_id=?",$photo_id)->limit(1);

$result=$query->query()->fetch();

$result['storage_path'] //has the path to your photo

Selecting random row from mysql database

Here is a simple query to select random row from a phpmysql database

Select * from `users` ORDER BY rand() limit 0,1

where users is the name of my table