Using the $adb object

[joebordes]

$result contains a record set, in other words, a collection of many rows, in this case many invoice rows.

Try this:

PHP Code:

<?php
include_once('vtlib/Vtiger/Module.php');
global $current_user,$adb;

    $query = "SELECT `invoiceid`, `subject`, 'subtotal' FROM `vtiger_invoice`";
    $result = $adb->pquery($query,array());
echo "<pre>";
while ($row=$adb->fetch_array($result)) {
 print_r($row);
}
echo "</pre>";    
?>