Thread

Hi There,

I want to order my members on the contact page of my site. However I need to be able to ajust the order from time to time. I have therefore created a custom member field called display_order and told EE to display this on the site like so:

<ul id="users" class="container">
  {exp:query sql='SELECT member_id, email AS "email_plain" FROM exp_members WHERE member_id <> 1 AND group_id = 1 OR group_id = 6 ORDER BY screen_name'}
  {exp:member:custom_profile_data member_id='{member_id}' parse='inward' order_by='display_order' sort='asc'}
  <li>
    {if avatar}
    {avatar_url}
    {if:else}
        {site_url}images/uploads/img_defaults/{default_staff_image}
    {/if}
    <ol>
      <li>{screen_name}</li>
      {if position != ''}<li><strong>{position}</strong></li>
        {if:else}
        <li>Position Not Entered</li>{/if}
      <li>{email}</li>
    </ol>
  </li>
  {/exp:member:custom_profile_data}
  {/exp:query}
</ul>

The part I am editing without much success is the line:

{exp:member:custom_profile_data member_id='{member_id}' parse='inward' order_by='display_order' sort='asc'}

order_by='display_order' sort='asc'

I am not having much success. Can anyone see what the problem is?

Thanks.

{exp:member:custom_profile_data} does not support an order_by= parameter, I am afraid. Perhaps you should be doing all of this within the SQL query?

Ok, so can you give me an example of what I should be doing?

Another question.. is position and the sort order the only thing you want to have in the custom member fields?

What are you trying to order?

I also have Job Title as a custom field.

The members are displayed on the contact page in a list and I want to be able to change their order. Not by date or id but by a custom field.

Thanks.

Are you familiar with the syntax for joining tables in a SQL query? You’ll need to build a query to display what you want. But the problem is that there are two tables you’ll need to join.

Hi Sue,

No I am not familiar with how to do that. Can you please give me an example?

Thanks.

GlobalGraphics,

I can’t give you an exact query unfortunately but here is an example of a join

{exp:query sql="
SELECT exp_categories.cat_id AS cat_id,exp_categories.cat_url_title AS cat_url_title
FROM exp_categories  
JOIN exp_category_posts
ON exp_categories.cat_id=exp_category_posts.cat_id
WHERE
exp_category_posts.entry_id = {entry_id}"
}

I can move this thread to the CodeShare Corner if you wish and let the community get involved?

Hi John,

Yes please codeshare corner sounds great.

Thanks.

Moving as per request.

Hello Codeshare corner!

Can anyone give me an example of what I need to do here?

Thanks.