Query DB and return results in field or table

[kblackwell]

Well, seeing how I don't know if tables can be used in a view, (Already submitted that question and waiting on reply from forum), but if someone can answer that too, would be appreciated.

But the real question is can someone point me in a direction to find information on returning results from a db query into sugar?

Thanks in advance.

[matthew]

something like this:

global db;

$result = $db->query("SELECT * FROM contacts");
while($row = $this->db->fetchByAssoc($result)) {
print "field value: " . $row['field'];
}