how is convert this code to CodeIgniter code?

[eluser]Zaher Ghaibeh[/eluser]
can you put your full code so we can spot the error ??
since if you want to get an array out of your code you can use

Code:

$query->result_array();

not

Code:

return $query->row();

which will result only one row, and you didnt limit your sql statement with limit().
but if you want to get all the results you have to use

Code:

$query->result();