title: PHP query to search multiple tables in MySQL database?
body: <p>I've read through a few of these responses and I'm not sure I'm understanding how to go about this. I'm completely new to this, and feel a little lost. Right now, I have a PHP query that echos data from one table. I have a database that generates a new table every day. I need to be able to constantly search that database for values across all tables.</p>
  
  <p>Here is my code at present:</p>
  
  <pre><code>&lt;?php
  $dbc = mysql_connect ('localhost','root','abcde');
  
  if (!$dbc){
      die('Not Connected:' . mysql_error ());
  }
  
  $db_selected = mysql_select_db ('game_database', $dbc);
  
  if (!$db_selected) {
      die ("Can't Connect :" .mysql_error());
  }
  
  $query="SELECT * FROM `03-31-14` WHERE GAME='Clash of Clans'";
  
  $result=mysql_query($query);
  
  if (!$query){
      die ("Can't Connect :" .mysql_error());
  }
  
  while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
      echo $row['GAME'];
      echo $row['REVENUE2'];
      echo $row['ARPU'];
      echo $row['DAILY_NEW_USERS'];
  }
  ?&gt;
  </code></pre>
  
  <p>Is there a way to modify this so I can search for similar information across all of my tables?</p>
  
  <p>Thanks!</p>