Method:
fetchRow()
Class:
SQL
Method Call:
include_once("core/sql/SQL.php");
$db = new SQL();
ASSOC_ARRAY $db->fetchRow(ADODB_RECORDSET: $recordset);
Description:
Returns one associative array of SQL field names => field values based on $recordset as returned by the select() method.
Usage:
For example (assuming the database object exists within a class as $this->db):
include_once("core/html/HTML.php");
$html = new HTML();
$fields = array(array("title" => "t"), array("subtitle" => "st"));
$pString = "RESULTS: ";
$recordset = $this->db->select(array("WKX_resource"), $fields);
$row = $this->db->fetchRow($recordset);
foreach($row as $value)
print $html->dbToHtmlTidy($value) . "<br />";