Re: [PHP-DB] PHP and table/view names with '$'

What if you use back-quotes `` around the table/view name? 

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


----- Original Message ----- 
From: <[email protected]>
To: "Mark Casson" <[email protected]>; <[email protected]>
Sent: Thursday, April 23, 2009 5:25 AM
Subject: RE: [PHP-DB] PHP and table/view names with '$'


I find that using single quotes rather than double quotes prevents
variable substitution.

I don't know if this is an undocumented feature, as the documentation
says that both have the same functionality.

Regards, 
Neil

-----Original Message-----
From: Mark Casson [mailto:[email protected]] 
Sent: 23 April 2009 11:04
To: [email protected]
Subject: [PHP-DB] PHP and table/view names with '$'

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 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php