Hello Guys ,
I am new to expression engine and am starting my career with expression engine and i need some help from you guys . I resolved many of my problems reading your answers . My issue is that i want to show the avatars and screen name and date of joining of the members on my page . Only those member which are assigned to a particular project , for that i run a sql query to get id’s of those members but i don’t know how to display them . Here is my code ::
[color=blue][size=3]{html_header}
<?php
$query_sea = $this->EE->db->query('SELECT member_id FROM `exp_eedonations_custom_fields` WHERE custom_field_value="15"');
foreach($query_sea->result_array() as $row)
{
echo $row['member_id']."
\n";
}
?>
{exp:member:custom_profile_data member_id="?"}
{if avatar}
{avatar_url}
{/if}<br>
{screen_name}<br>
{join_date format="%Y %m %d"}<br>
{/exp:member:custom_profile_data}
{html_footer}
[/size][/color]