title: How to execute two mysql queries as one in PHP/MYSQL?
body: <p>I have two queries, as following:</p>
  
  <pre><code>SELECT SQL_CALC_FOUND_ROWS Id, Name FROM my_table WHERE Name LIKE '%prashant%' LIMIT 0, 10;
  SELECT FOUND_ROWS();
  </code></pre>
  
  <p>I want to execute both these queries in a single attempt. </p>
  
  <pre><code>$result = mysql_query($query);
  </code></pre>
  
  <p>But then tell me how I will handle each tables set separately. Actually in ASP.NET we uses dataset which handles two queries as</p>
  
  <pre><code>ds.Tables[0];
  ds.Tables[1]; .. etc
  </code></pre>
  
  <p>How can I do the same using PHP/MYSQL?</p>