Performing query on returned data

[eluser]Unknown[/eluser]
I was just wondering if it's possible to run a query on data that has been returned from a previous query? For example, if I do

Code:

$sql = "My query";
$query = $this->db->query($sql);

Is it then possible to run a second query on this data such as

Code:

$secondquery = $this->db->query("My second query",$query);

Thanks for any help

[eluser]Kyle Johnson[/eluser]
I think you may have to do something like this:

Code:

$sql = "SELECT TOP 1 id, status, name FROM user WHERE id=3";  // specific user
$query1 = $this->db->query($sql);

$sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?"; // query_binding
$query2 = $this->db->query($sql, $query1->row_array());  // query1 returns only a single value

I'm not sure if this will work.

Code:

$sql = "SELECT TOP 15 id, status, name FROM user WHERE status='live'";  // 15 users
$query1 = $this->db->query($sql);

$sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?"; // query_binding
$query2 = $this->db->query($sql, $query1->result_array());  // not sure if this will work