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:

Code:
Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 MEDNO                                  NOT NULL NUMBER(7)
VISIT_DATE_TIME                   NOT NULL TIMESTAMP(6)
This is my php code:
PHP Code:
 $stmt OCIParse($conn$sql);
  
  
$result OCIExecute($stmtOCI_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]&nbsp;</TD>\n";
                }
    
                print 
"</TR>\n";
  }
  print 
"</TABLE>"
Please let me know if there is something that I am doing wrong. Thanks.