Retrieve a column value (php/oracle)

amrigo

I am using pph/oracle, and need to retrieve the value from a specifically collumn,

I try assign value from an array " $nrows['NOME_OPER']; "
wich comes from an ocifetchstatement();

But it did not bring the result i need .

$db_conn = ocilogon("x", "x", "x");
$cmdstr = "SELECT NAME_OPER, x, x FROM x ";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
$nrows = ocifetchstatement($parsed, $results);

if($nrows>0){
$_SESSION['nome']= $nrows['NAME_OPER']; //My attempt !
header ("location: index1.php");
} else {
header ("location: index.htm");
}
OCIFreeStatement($cmdstr);
OCILogoff($db_conn);

Thank´s in advance

YappyDog

You seem to flipflop between using nome and name, NOME and NAME. I hope those are just typos on your posting and not in your code.....

Anyway, the problem is that you are trying to get your table data out of the $nrows variable. $nrows contains the number of rows returned by your fetch. Your results are in the $results variable. Look at the example for the ocifetchstatement function in the manual.

http://us4.php.net/manual/en/function.ocifetchstatement.php

amrigo

I just was translating to english (nome to name), i try with ocifetchinto too but i do get the error "ocifetchstatment out of sequence":
(the query is ok believe me!, 'NOME_OPER' is a column name)

<?php
session_start();
$nome = $POST['usuario'];
$SESSION['usuario'] = $nome;
$orgao = $POST['orgao'];
$usuario = $POST['usuario'];
$db_conn = ocilogon("x", "x", "x");
$cmdstr = "SELECT x, x, x, FROM y, y WHERE x= 'x' AND x = '$orgao' AND x = '$usuario' AND x= x AND x= x";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed);
while (ocifetchinto ($parsed, $row, OCI_ASSOC)) {
$SESSION['nome'] = $row['NOME_OPER'];
//$SESSION['codigo'] = $row['CODIGO'];
}
$nrows = ocifetchstatement($parsed, $results);
if($nrows>0){
header ("location: index1.php");
} else {
header ("location: index.htm");
}
OCIFreeStatement($cmdstr);
OCILogoff($db_conn);
?>

Cheers

amrigo

So i did :
$parsed
and
$parsed1
one to use with fetchinto
and other to use with fetchstatment
and it works!
it is an ugly solution?

Greetings from Brasil