Using the $adb object

[Guido1982]

Ah, and that is why the array is flattened within the 'pquery' method, to make sure there are no layered arrays going into the query.

---

I truly don't understand what I'm doing wrong then. My query code is:

Code:

<?php

    require "include/database/PearDatabase.php";

    $query = "SELECT `invoiceid`, `subject`, 'subtotal' FROM `vtiger_invoice`";
    $result = $adb->pquery($query,array());

    ?><pre><?php print_r($result); ?></pre><?php
    
?>

But all it returns is an object called 'ADORecordSet_mysql' containing only the first row...