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

Hi,

For reference, this didn't work, but just using single quotes instead of 
double quotes did.

Mark

""Yves Sucaet"" <[email protected]> wrote in message 
news:006201c9c3ff$4896f7e0$0402a8c0@rincewind...
> 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
>
>
>