I have a website which has users and each user can creat multiple
product records. I have the ability to show the associated records under
the user profile but what I want to do now is on the user index, to
display a number representing how many products that user has up for
sale. So basically to count all the records for each user and display on
the index so that it would look like the following e.g.
Username Favourite Console Games available to trade
jimmypop01 Playstation 3 0
andypandy Playstation 3 3
GoogleMail Playstation 3 2
I was wondering if anyone knows how I would go about doing this.
All I have managed so far is to display how many records are in that
So that people know I have two separate tables for users and games.