I am writing a php script that queries an Oracle 9i database and I cannot extract any columns that are of type TIMESTAMP.
This is my database:
Name Null? Type
----------------------------------------- -------- ----------------------------
MEDNO NOT NULL NUMBER(7)
VISIT_DATE_TIME NOT NULL TIMESTAMP(6)
This is my php code:
$stmt = OCIParse($conn, $sql);
$result = OCIExecute($stmt, OCI_DEFAULT);
// get the information of columns and rows
$ncols = OCINumCols($stmt);
$nrows = OCIFetchStatement($stmt, $result);
print "<P><TABLE CELLSPACING=\"0\" CELLPADDING=\"3\" BORDER=\"1\" ALIGN=\"center\" width=\"100%\">\n";
print "<TR bgcolor = #105F88>";
while ( list( $key, $val ) = each( $result ) ) {
print "<Td>$key</Td>\n";
}
print "</TR>\n";
// print the data
for ($j=0; $j<$nrows; $j++) {
reset($result);
print "<TR>";
//loop through result
while ($column = each($result)) {
$data = $column['value'];
print "<TD>$data[$j] </TD>\n";
}
print "</TR>\n";
}
print "</TABLE>";
Please let me know if there is something that I am doing wrong. Thanks.