I have a situation where i need to get data from 7 different tables for a particular processing to be performed. 

I will need 7 simple `SELECT` all statements, nothing fancy. But to minimize the database hit, I will very much like to bundle these queries into 1 or 2 queries. 

Like: 

```
select * from table1; select * from table2; select * from table3;. 

```

And will call this query from my code. Is is possible to get the results in something on the similar lines of .net's DataSet in PHP. I am looking for a solution in core PHP or CodeIgniter. I am using PDO for database connection.

PS: The tables have different schemas, no common point. So any solution with join or union will not work.

```
$results = $this->db-query("select * from tb1; select * from tb2");

```

now `$result[0]` should have all the records from tb1 and `$results[1]` should have the records from tb2.

Something on the similar line will be most helpful in this scenario.