Escape the embedded single quotes i.e. $stmt = OCIParse($conn, 'SELECT * FROM v$sql WHERE INSTR(SQL_TEXT,\'something\')>0');
Neil -----Original Message----- From: Mark Casson [mailto:confu...@icube.co.uk] Sent: 23 April 2009 12:10 To: php-db@lists.php.net 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"" <confu...@icube.co.uk> wrote in message news:89.4e.33545.c2d30...@pb1.pair.com... > 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