Re: [PHP-DB] Re: PHP and table/view names with '$'
[email protected] ("Mark Casson")
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
i was absolutely convinced that i tried to escape the $ and it hadn't worked and got side tracked looking at other options . . . but yes, that indeed works perfectly. Thanks a lot! ""Yves Sucaet"" <[email protected]> wrote in message news:007d01c9c404$97d4d1b0$0402a8c0@rincewind... > Switch back to double quotes? :-) > > $stmt = OCIParse($conn, "SELECT * FROM v\$sql WHERE > INSTR(SQL_TEXT,'something')>0"); > > ----- Original Message ----- > From: "Mark Casson" <[email protected]> > To: <[email protected]> > Sent: Thursday, April 23, 2009 6:10 AM > Subject: [PHP-DB] Re: PHP and table/view names with '$' > > >> Hi, >> >> Of course, the next problem is that i want to specify a line to find: >> >> $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE >> INSTR(SQL_TEXT,'something')>0'); >> >> and i seem to have to use single quotes in the INSTR function. >> >> Is there an alternative way to deal with that? >> >> Thanks again >> >> Mark >> >> ""Mark Casson"" <[email protected]> wrote in message >> news:[email protected]... >>> 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 >> >