note 112588 added to pdo.quote

From: Date: Tue, 02 Jul 2013 09:27:04 +0000
Subject: note 112588 added to pdo.quote
Groups: php.notes 
Request: Send a blank email to php-notes+get-195431@lists.php.net to get a copy of this message
Hello, I am unable to fetch information from "systables" from an external schema. Find below query which I am trying to execute from PHP "SELECT * FROM {schema_name}:systables" When we pass this query to "prepare" function then it is failing because we used column(:) in the FROM part. The reason is we can't bind values to identifiers like tables and columns. But here my intention is not to bind the table name but to refer a table in that schema. Is there a way that I can run this query in PHP. I tried several ways but no use and also I posted it in other forums but no one is able to reply. Please provide me a solution asap. -- Regards, Lalith ---- Server IP: 69.147.83.199 Probable Submitter: 103.22.239.215 ---- Manual Page -- http://php.net/manual/en/pdo.quote.php Edit -- https://master.php.net/note/edit/112588 Del: integrated -- https://master.php.net/note/delete/112588/integrated Del: useless -- https://master.php.net/note/delete/112588/useless Del: bad code -- https://master.php.net/note/delete/112588/bad+code Del: spam -- https://master.php.net/note/delete/112588/spam Del: non-english -- https://master.php.net/note/delete/112588/non-english Del: in docs -- https://master.php.net/note/delete/112588/in+docs Del: other reasons-- https://master.php.net/note/delete/112588 Reject -- https://master.php.net/note/reject/112588 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#195431) next »