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

2009-04-23 Thread Yves Sucaet
Sucaet" $name4 = "\$name Sucaet";// "$name Sucaet" hth, Yves ----- Original Message - From: To: "Mark Casson" ; Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP and table/view names with '$' I find that using single quotes rat

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

2009-04-23 Thread Mark Casson
se($conn, "SELECT * FROM `v$sql`"); > > > - Original Message - > From: > To: "Mark Casson" ; > Sent: Thursday, April 23, 2009 5:25 AM > Subject: RE: [PHP-DB] PHP and table/view names with '$' > > > I find that using single quotes

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

2009-04-23 Thread Yves Sucaet
What if you use back-quotes `` around the table/view name? $stmt = OCIParse($conn, "SELECT * FROM `v$sql`"); - Original Message - From: To: "Mark Casson" ; Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP and table/view names with '$&#x

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

2009-04-23 Thread N . A . Morgan
co.uk] Sent: 23 April 2009 11:04 To: php-db@lists.php.net 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 m

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

2009-04-23 Thread Mark Casson
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 (