I have trouble finding a good solution to the following tasks:

Schema 1:
item:
  id:
customer:
 item_id:

I need to output a list of customers  with assigned items:

customer1
  itemA
  itemB
customer2
  itemC

Of course I can retrieve customers and items in two arrays and do some
dirty stuff in the action or template using php but I know there are
better solutions.

-------------------------------------
Schema2:

user:
  id:
group:
  id:
user_in_group:
  user_id:
  group_id:

Users can be memebers of multiple groups. I need to output a list of
groups with assigned users:
group1
  userA
  userB
group2
 userB
 userC

Again I'm looking for a better solution than getting two array and
going through them in several loops ;-)
Sorry for posting very basic questions more related to db queries than
symfony but I will have to find a solution to use within symfony right
away.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to