SugarCRM Database Query

Database query functions:

$bean->db or $GLOBALS[‘db’] or global $db are the objects of the databases.

// to execute the query

$result = $bean->db->query($query, true);

$result = $GLOBALS['db']->query($query, true);

In this $query variable will have the query that you want to execute.

//To get the rowcounts:

$rowcount = $bean->db->getRowCount($result);

$rowcount = $GLOBALS['db']->getRowCount($result);

This will return the number of rows affected or fetched in the variable $rowcount

//To fetch the data:

$resultData = $bean->db->fetchByAssoc($result);

$resultData = $GLOBALS['db']->fetchByAssoc($result);

You can get the all data by the passing the $resultData variable in the while loop.

SugarCRM