Hello.
I'm running php5 with oracle 9i.

First,I created a basic select statement to check connectivity to the oracle db and to get a result. This was successful.

Now, I modified this select statement to retrieve the information from two fields. These fields are named with dollar signs in them. I keep getting a ora_parse failed. My script and error follows....

----script------
<?php
include("conn.php");
$mysql = "select t$orno, t$cuno from orders where t$orno = 123456";
$mycursor = ora_open($conn)
ora_Parse($mycursor, $mysql, 0)
ora_Exec($mycursor)

print('<table>');
while (Ora_Fetch($mycursor)){
    printf('<tr><td>%s</td></tr>', ora_getcolumn ($mycursor, 0));
}
print('</table>');
ora_logoff($conn);
?>

----- error --------
Warning: ora_parse() [function.ora-parse]: Ora_Parse failed (ORA-00904: "T": invalid identifier -- while processing OCI function OPARSE)


-------------------
Any help is appreciated...
Thanks,
-Tim

It's the fieldnames. I reckon $orno is coming up as an empty string, so that your statment then becomes:

select t, t from orders where t = 123456

Oracle's saying "There's no such field as 't'". Try:

echo $mysql
(a somewhat misleading name for an SQL string, if I may make so bold :)

Before you execute it. that will show what you are trying to actually run, and should make the error apparent.

Take it easy
Dan