im using Oracle OCI functions
i am trying to use session variables, i have them working but i want to register the query results from
the Oracle sql query as session variables.
select * from sys.richie where username='$username';
i want to register the column results as session variables. The columns are;
USERNAME,PASSWORD(already registered)
NAME,
ADDRESS,
PHONE,
CC,
CC_DETAILS,
i tried registering them as variables first;
$name="NAME";
session_register('name');
$_SESSION['name']=$name;
but this actually registers it as the string "NAME" rather that the column "NAME" in the database.
How do i get the results from the query so that i can register them as session variables.
Can i use the OCIResults function?