I am using doctrine 2.1 in order to create a model for settings
table:
id | arg | value | category
1 | name | foo | general_settings
2 | desc | bar | general_settings
Suppose that I have a lot of setting for different categories. In order to get all the setting for a specific category I do something like this:
$q = Doctrine_Query::create()
->from('Setting p')
->where('p.category = ?', $category_name);
Everything works fine at this point. Well.. the question of $64,000 is: Do exist a data access alternative that allow me to read the result as below?
$resultSet = $q->execute();
//the magic here could be use the -arg- column as index
$requested_setting = $resulSet['name']
//print the setting value
echo $requested_setting['value']; //should prints "foo"
//another way
echo $resulSet['desc']['value']; //should prints "bar"
See Question&Answers more detail:os