title: USER_TAB_COLUMNS doesn't exist
body: <p>I am trying to create a dynamic form of inputs to register a user, so I need to select the columns which I have inside the users table such as (username - email - password-...etc.) so I got this code from some question around here</p>
  
  <pre><code>$query = " SELECT table_name, column_name, data_type, data_length ";
  $query.=" FROM USER_TAB_COLUMNS ";
  $query.=" WHERE table_name = 'user_type' ";
  $result= mysqli_query($db, $query)
  
  if (mysqli_num_rows($result) &gt; 0) {
  while ($row = mysqli_fetch_assoc($result)) {
      print_r($row);
  } //end while
    } //end if
  </code></pre>
  
  <p>Then if I applied this inside PHP I get this</p>
  
  <blockquote>
    <p>mysql_num_rows() expects parameter 1 to be resource, boolean given in</p>
  </blockquote>
  
  <p>Which means the select statement didn't work probably.
  But when I apply it to phpMyAdmin SQL it gives me this error</p>
  
  <blockquote>
    <p>Table 'final_main.user_tab_columns' doesn't exist</p>
  </blockquote>
  
  <p>Which tells me that I don't have this table inside my DB</p>