title: I Don't want to show some tables and some column in mysql while generating my record
body: <p>Since I have given to administrator to created the form dynamically.when he created form,What I have done is I have created the table for the form dynamically.Every thing is working fine.Now <strong>I want to show  table and column for report generation</strong>.In that I don't want to show <strong>(userlogin,place,venue)</strong> table for report generation and three columns <strong>(user_id,user_common_id,ayear)</strong> these three column are common for all the table which I created dynamically . I have given my code what I have done so far.</p>
  
  <p>Guide me How to write the mysql query for this.</p>
  
  <pre><code>&lt;?php
      $mysqli = new mysqli("localhost", "root", "", "event");
      $result = $mysqli-&gt;query("SHOW TABLES");
      while ( $row = $result-&gt;fetch_row() )
      {
      $table = $row[0];
      echo '&lt;h3&gt;',$table,'&lt;/h3&gt;';
      $result1 = $mysqli-&gt;query("SELECT * FROM $table where ayear='1'");
      if($result1) 
      {
      echo '&lt;table cellpadding="0" cellspacing="0" class="db-table"&gt;';
      $column = $mysqli-&gt;query("SHOW COLUMNS FROM $table");
      echo '&lt;tr&gt;';
      while($row3 = $column-&gt;fetch_row() ) 
      {
      echo '&lt;th&gt;'.$row3[0].'&lt;/th&gt;';
      }
      echo '&lt;/tr&gt;';
      while($row2 = $result1-&gt;fetch_row() ) 
      {
      echo '&lt;tr&gt;';
      foreach($row2 as $key=&gt;$value) {
      echo '&lt;td&gt;',$value,'&lt;/td&gt;';
      }
      echo '&lt;/tr&gt;';
      }
      echo '&lt;/table&gt;&lt;br /&gt;';
      }
      }
      $mysqli-&gt;close();
      ?&gt;
  </code></pre>
  
  <p>When admin created the forms, here is code for dynamic table and columns.for better projection</p>
  
  <pre><code>$query1="create table ".$porg."(id INT NOT NULL AUTO_INCREMENT,".$VALUES.",user_id int(11),user_common_id int(11),ayear varchar(30),PRIMARY KEY (id)) ENGINE = INNODB"; 
        $result=mysql_query($query1);
  </code></pre>