[Lynne]

I would use fetch_array in case you to later have multiple rows and you should specify the field you want. Assuming you want history.field, then:

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "history");
 
$l_history['field'] = '';
while ($l_history = $db->fetch_array($result)){
    $history['field'] .= $l_history['field'];
} 


and then in the template:

{vb:raw history.field}