I am writing an application that each sales agent has their own rates for each product with pre-defined categories. For example, my MySQL table has the following fields
When I query this table my WHERE clause will provide the agent_id.
Since there are multiple of products, I will get back multiple of rows, and I am doing this via PDO.
My question is, is it possible that I return this as a two-dimensional array, for example:
$agent['roller_coaster']['family'] = 49.99, where of course, roller_coaster is my product id?