title: PHP syntax for postgresql Mixed-case table names
body: <p>I have a code below:</p>
  
  <pre><code>&lt;?php
  require "institution.php"
  /* in this portion, query for database connection is executed, and  */
  
  $institution= $_POST['institutionname'];
  
  $sCampID =  'SELECT ins_id FROM institution where ins_name= '$institution' ';
  $qcampID = pg_query($sCampID) or die("Error in query: $query." . pg_last_error($connection));
  /* this portion outputs the ins_id */           
  ?&gt;
  </code></pre>
  
  <p>My database before has no mixed-case table names, that's why when I run this query, it shows no error at all. But because I've changed my database for some reasons, and it contains now mixed-case table names, i have to change the code above into this one:</p>
  
  <pre><code>$sCampID =  'SELECT ins_id FROM "Institution" where ins_name= '$institution' ';
  </code></pre>
  
  <p>where the Institution has to be double quoted. The query returned parse error.
   When i removed this portion: where ins_name= '$institution', no error occured.</p>
  
  <p>My question is how do I solve this problem where the table name which contains a mixed-case letter and a value stored in a variable ($institution in this case) will be combined in a single select statement?</p>
  
  <p>Your answers and suggestions will be very much appreciated. </p>