[eluser]xico[/eluser]
Hi all
I am developing one app using CI.I am doing well,but now I am on the stage where I need to run mysql query under loop in VIEW file.
I have written a search query where I can't join any other table. this query returns me a array of data. I have passed this array into VIEW. this data contains ID which values are in another table. so can i write a query in VIEW?
for example
Code:
for($i=0;$i<count($data);$i++)
{
$cid = $data[$i]['id'];
}
Now with the use of $cid value I need to fetch username from another table. so how can I get it on VIEW.
Please Guide.
Thanks