Oracle

[cqball2000]

Is there an easier way to write this:

    $selectStmt =ociParse($connection,$sql); 

        ociExecute($selectStmt); 
        while(ociFetch($selectStmt)) 
        { 
        $tableColumns = ociNumCols($selectStmt); 
        for($nc = 1; $nc <= $tableColumns; $nc++) 
        { 
        $column[(ociColumnName($selectStmt, $nc))] = ociResult($selectStmt, $nc); 
        }  

Also, how can I find the number of rows the results returned?

Thanks!
~Dave

[Anon]

Try OCIFetchInto(). For example:

//OCIFetchInto($stmt, &$columns, OCI_ASSOC+OCI_RETURN_NULLS)
//returns associative array $columns["COL1"], $columns["COL2"], etc.
//Without the OCI_ASSOC use $columns[0] for COL1, $columns[1] for COL2, etc.
while (OCIFetchInto($selectStmt, &$columns, OCI_ASSOC+OCI_RETURN_NULLS))
{ ...do whatever you want here... }

Also, how can I find the number of rows the results returned?

How about something like:
$sql = "SELECT COUNT(1) rowcount FROM ... WHERE ...";
$countStmt = ociParse($connection, $sql);
ociExecute($countStmt);
ociFetch($countStmt);
$rowcount = ociResult($countStmt, 1);

-- Michael
Darkstreak Consulting
www.darkstreak.com