Re: [PHP-DB] Re: PHP and table/view names with '$'
[email protected] ("Yves Sucaet")
| Newsgroups | php.db |
|---|---|
| Message-ID | <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 > >