just a quickie

[eluser]ray73864[/eluser]
you need to either use row() on the data, eg:

Code:

$shop_id = $this->data->row()->shop_id;

or something else in order to get it out, since you have a where clause and a limit there just using 'row()' should work fine for you.