Looping through mysql queries?

[eluser]Dirk Einecke[/eluser]
Hi,

something like this (not tested):

Code:

$arr_result = $this->db->query('SELECT DISTINCT PersonalPage FROM TBL_USERS WHERE UserName = \'BOB\' LIMIT 1')->result_array();
$arr_result = $this->db->query('SELECT itemName FROM TBL_ITEMS WHERE itemID IN ('. $arr_result[0]['PersonalPage'].')')->result_array();

print_r($arr_result);

Dirk