Ok, thanks for the help. I think I'll scrap what I have done, and start over with it.
Back to the original working code...
Do you have any suggestions on how to get it to not list the members who have not entered the info into the custom field?
I believe it needs to be done in this section:
$num = 0;
//GET gamertag and info
while($rows = mysql_fetch_array($sql))
{
if($counter % 2 == 0){$color = "list-item1";}
if($counter % 2 != 0){$color = "list-item2";}
$gamerid = $rows['member_id'];
$query = "SELECT * FROM ibf_members WHERE id = '$gamerid'";
$query = mysql_query($query);
$row = mysql_fetch_array($query);
if($rows['field_1'] == '')
{
$username = "???";
}
else {
$username = $rows['field_1'];
}
echo "
<tr>
<td class=\"$color\">$username</a></td>
<td class=\"$color\"><br></td>
<td class=\"$color\"><a href=\"/xbox_forums/index.php?act=Profile&CODE=03&MID=".$row['id']."\">".$row['name']."</a></td>
</tr>
";
$counter++;
$num++;
}
This part of it which is halfway into that section
if($rows['field_1'] == '')
{
$username = "???";
}
Is where it assigns ??? for their gamertag (which is the custom field). When it lists the users, it basically displays:
??? - Member's board name
I'd like for it to just completely leave their name off of the list though. I have an idea on what needs to be done, but I have no clue how to do it.
