title: php/mysql with multiple queries
body: <pre><code>&lt;?php
  
  $query1 = "CREATE VIEW current_rankings AS SELECT * FROM main_table WHERE date = X";
  
  $query2 = "CREATE VIEW previous_rankings AS SELECT rank FROM main_table WHERE date = date_sub('X', INTERVAL 1 MONTH)";
  
  $query3 = "CREATE VIEW final_output AS SELECT current_rankings.player, current_rankings.rank as current_rank LEFT JOIN previous_rankings.rank as prev_rank
               ON (current_rankings.player = previous_rankings.player)";
  
  $query4 = "SELECT *, @rank_change = prev_rank - current_rank as rank_change from final_output";
  
  $result = mysql_query($query4) or die(mysql_error()); 
  
  while($row = mysql_fetch_array($result)) {
  echo $row['player']. $row['current_rank']. $row['prev_rank']. $row['rank_change'];
  }
  
  ?&gt;
  </code></pre>
  
  <p>All the queries work independently but am really struggling putting all the pieces together in one single result so I can use it with mysql_fetch_array.</p>
  
  <p>I've tried to create views as well as temporary tables but each time it either says table does not exist or return an empty fetch array loop...logic is there but syntax is messed up I think as it's the 1st time I had to deal with multiple queries I need to merge all together. Looking forward to some support. Many thanks.</p>