Thread

I have a channel that displays all students called students, which is laid out as like a profile and a channel called grades which unsurprisingly displays grades.

At the bottom of the students profile, I want to display their grades. I am having an issue of matching grades to students as i can’t seem to get them per username.

I want the grades to be displayed per student even if a user is logged in or not logged in.

I have already seen about embedding a channel inside another channel, and that works fine. The issue is all users grades are being displayed for every user.

I have tried the relationship field, but i cannot seem to get author_id to match up with anything from the students channel.

I am using the free version of EE.

Thanks.

I have tried the relationship field, but i cannot seem to get author_id to match up with anything from the students channel.

This was the right track. I’d recommend going back to it. You shouldn’t need to worry about matching anything up. You would create a relationship field in the Students channel, and select their grades in it. Then when using a channel:entries loop in to pull student info you would use the relationship field code to pull grades.

Alternatively you could also probably look at using a Grid field in the Students channel to hold grades instead - unless there is a good reason for needing them in their own channel.

Great, thanks for the reply

I’m looking to do something like this

{exp:channel:entries channel="students" search:exam="GCSE"}
 {results_footer}
  {if count > 3 && count < 10}
   {site_url}images/badges/60/gcse-bronze.png
  {if:elseif count > 10 && count < 20}
   {site_url}images/badges/60/gcse-silver.png
  {if:elseif count < 3}
   {site_url}images/badges/60/locked.png
  {/if}
 {/results_footer}
{/exp:channel:entries}

Do you know how i would get the count?

Thanks.

http://ellislab.com/expressionengine/user-guide/add-ons/channel/relationships.html#namespacing-variables