Re: PHP and table/view names with '$'

Mark Casson wrote:

> Hi,
> 
> I am trying to access some of the v$ views using php on iis, with admin
> privileges.
> 
> However, using:
> 
> $stmt = OCIParse($conn, "SELECT * FROM v$sql");
> 
> gives me this error:
> 
> PHP Notice: undefined variable: sql . . .
> 
> Is there a way around this?
> 
> Thanks
> 
> Mark

Try enclosing your query in single quotes so php doesn't try to expand what
it sees as the variable $sql. For example

$stmt = OCIParse($conn, 'SELECT * FROM v$sql');


Cheers
-- 
David Robley

I am Homer of Borg. Prepare to be assim... mmmm, donuts.
Today is Pungenday, the 40th day of Discord in the YOLD 3175.