";
for ($i=0; $i < $ncols; $i++) {
if ($i===0) $v=($numoffset) ? $rs->fields[0] : reset($rs->fields);
else $v = ($numoffset) ? $rs->fields[$i] : next($rs->fields);
$type = $typearr[$i];
$s .= "\n ";
switch($type) {
case 'D':
if (empty($v)) $s .= "| | ";
else if (!strpos($v,':')) {
$s .= " ".$rs->UserDate($v,"D d, M Y") ." | ";
}
break;
case 'T':
if (empty($v)) $s .= " | \n";
else $s .= "".$rs->UserTimeStamp($v,"D d, M Y, h:i:s") ." | ";
break;
case 'I':
case 'N':
$s .= "".stripslashes((trim($v))) ." | ";
break;
/*
case 'B':
if (substr($v,8,2)=="BM" ) $v = substr($v,8);
$mtime = substr(str_replace(' ','_',microtime()),2);
$tmpname = "tmp/".uniqid($mtime).getmypid();
$fd = @fopen($tmpname,'a');
@ftruncate($fd,0);
@fwrite($fd,$v);
@fclose($fd);
if (!function_exists ("mime_content_type")) {
function mime_content_type ($file) {
return exec("file -bi ".escapeshellarg($file));
}
}
$t = mime_content_type($tmpname);
$s .= (substr($t,0,5)=="image") ? "  | \\n" : " $t | \\n";
break;
*/
default:
if ($htmlspecialchars) $v = htmlspecialchars(trim($v));
$v = trim($v);
if (strlen($v) == 0) $v = ' ';
$s .= "". str_replace("\n",'
',stripslashes($v)) ." | ";
}
} // for
$s .= "\n
\n\n";
$rows += 1;
if ($rows >= $gSQLMaxRows) {
$rows = "