How to extract vtiger DB data

Here is the code sample how extract data form vtiger DB with WHERE close.
Sample:1

  

require_once('include/DatabaseUtil.php');

global $adb;

$tabid = array('9','16');

$sql = "SELECT tabid, fieldname, fieldid, fieldlabel,columnname, tablename, uitype,
 typeofdata, presence FROM vtiger_field WHERE tabid in 
(" . generateQuestionMarks($tabid) . ")";

$result = $adb->pquery($sql, array($tabid)); // get result
$noofrows = $adb->num_rows($result); // get number of rows

$i=0;
$data=array();
while($resultrow = $adb->fetch_array($result)) {
$tabid=$resultrow['tabid'];
$resultrow=['fieldlabel'];
$data[$i]=array($tabid, $resultrow);
}

Sample:2

require_once('include/DatabaseUtil.php');

global $adb;
$query = 'select idlists,from_email,to_email,cc_email,bcc_email from
 vtiger_emaildetails where emailid =?';

$result = $adb->pquery($query, array($focus->id));
$from_email = $adb->query_result($result,0,'from_email');