Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

RE: [PHP-DB] oracle8 From: indrek siitan (tfr <email protected>)
Date: 12/01/00

Hi,

a very simple example:

  <?
    $query="SELECT col1,col2 FROM table ORDER BY col1";
    $sth=OCIParse($GLOBALS["DBH"],$query);
    OCIExecute($sth);
    while (OCIFetchInto($sth,&$row,OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS))
    {
  ?>
  <TR>
  <TD><?= $row["COL1"] ?></TD>
  <TD><?= $row["COL2"] ?></TD>
  </TR>
  <?
    }
    OCIFreeStatement($sth);
  ?>

NOTE: the column names in $row MUST BE uppercase.

hope that helps.

Rgds,
  Tfr

  --==< tfr <email protected> >==< http://tfr.cafe.ee/ >==< +372-50-17621 >==-- 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>