How do i use mysql_num_rows

[chetansharma05]

Hi all, how can i use mysql_num_rows function in sugarcrm

[andopes]

Hi chetansharma05

The database object in Sugar, accessible in a module as $this->db has the method getRowCount.
You can use this way:

$num_row = $this->db->getRowCount($result);

Cheers.