Nested Query Question (NEWBIE)

[eluser]JesseR[/eluser]

class Mdl_country extends Model implements Iterator {

Is Implements Iterator the name of the model you made or
is this an actual function built into CI?

As you can see, in order to print the country-code, I ask a specialised method ‘getCode()’. In there I check what is written in the field and slightly modify it if a given rule matches.
In your case this method could be called ‘getPrice()’, where you could implement your own logic (if field is null, take another one etc.).

So I would have to create a special function for each field?

Example: I have an ITEM DESCRIPTION, LONG DESCRIPTION in both items and item_eq table.
If the value in the ITEM_EQ table is empty for any fields then we use the value of
the matching record in the ITEMS table.