Code: Select all
$dbconn->Connect($server, $user, $pass, $db);
$sSQL = 'select field1, field2 from table1';
$rs = $dbconn->Execute($sSQL);
$rs_array = $rs->GetArray();[...previous msg...]
I'm using ADODB to query data from a MSSQL db and then using the ADODB function rs2html() to display the recordset in html format. I would like to change some value in the recordset before displaying it with rs2html(). Not sure what function(s) to use...maybe array_walk()?
Example:
Code: Select all
$dbconn->Connect($server, $user, $pass, $db);
$sSQL = 'select field1, field2 from table1';
$rs = $dbconn->Execute($sSQL);
//some code to modify values in the recordset
rs2html($rs, 'border=5', array(field1, field2));Thanks