Thread

Imagine you have a weblog that has the custom field “eye_color.”  To get a list of all the colors submitted you would use the code:

{exp:weblog:entries weblog="xxxxx"}
{eye_color}

{/exp:weblog:entries}

With the above code, you are bound to get a list with several entries for brown, blue, green, etc.

Is there a way to code this so that each color only appears once in the list?  In other words, no identical data is repeated.

The easiest way to do this is with a query. You’d need to know which field contains eye_color and use that as a part of your query.

Something like this:

{exp:query sql="SELECT DISTINCT(field_id_4) as eye_color from exp_weblog_data where weblog_id='1'"}
{eye_color}

{/exp:query}

You might also look for Sortee - it’s a plugin by Mr. Wilson that can help with this.

I’d forgotten about Sortee. Thanks for the reminder!

Your code to do that using Sortee would look something like:

{exp:sortee}
{sortee:heading1}<h1>{heading}</h1>{/sortee:heading1}
{exp:weblog:entries weblog="the_eyes_have_it"}
{sortee:item}
{sortee:criterion}{eye_color}{/sortee:criterion}
{sortee:criterion}{name}{/sortee:criterion}
{name}'s eyes are {eye_color}

{/sortee:item}
{/exp:weblog:entries}
{/exp:sortee}

...which will give you something like:

<h1>Blue</h1>
Alice's eyes are Blue

Andrea's eyes are Blue

Zeus's eyes are Blue


<h1>Green</h1>
Henry's eyes are Green

Ian's eyes are Green

Lou's eyes are Green


<h1>Red</h1>
Opal's eyes are Red

Paul's eyes are Red

Hope that helps!