View Single Post

  #1 (permalink)  
Old 12-08-2005
Najm Hashmi
 
Posts: n/a
Default variable substitution

Hi All,
I have the following query:
$query="select CATEGORYID,CATEGORYCODE,ISLEAF from Category C where
C.TOPROOTID = {$TOPROOTID} AND C.PTID=0";

The value for $TOPROOTID does not get substituted. The same query works fine
in windows environment. Further more $TOPROOTID is being passed in URL as
following:
localhost/ViewDocument.php?TOPROOTID=1&ROOTLABEL=NT-proBNP%20and%20CHF&CATEG
ORYID=129

The OS is Red Hat9 and RDBMS is Oracle 9i.

The same code works fine in windows but on Linux I am having problem.
Thanks in advance for your help.

Best regards,
Najm



Reply With Quote