Current Members

Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id <= 3 ORDER BY rudi_ranks.weight DESC , rudi_unit_members.date_promotion ASC , rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); foreach($row as $member){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } CloseTable(); ?>

Previous Members

Rank	Soldier	Main Info	Service Record	Medal Record
{$member['shortname']}	{$member['first_name']} {$member['last_name']}	".LinkInternal('Edit','?op=rudi&show=members&profile='.$member['member_id'])."	".LinkInternal('Edit','?op=rudi&show=members&service='.$member['member_id'])."	".LinkInternal('Edit','?op=rudi&show=members&award='.$member['member_id'])."

Query("SELECT * FROM `rudi_unit_members` JOIN `rudi_ranks` ON rudi_unit_members.rank_id=rudi_ranks.rank_id WHERE rudi_unit_members.status_id > 3 ORDER BY rudi_ranks.weight DESC, rudi_unit_members.date_promotion ASC, rudi_unit_members.date_enlisted ASC"); $row = $db->Fetch($result); foreach($row as $member){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } CloseTable(); } ?>

Rank	Soldier	Main Info	Service Record	Medal Record
{$member['shortname']}	{$member['first_name']} {$member['last_name']}	".LinkInternal('Edit','?op=rudi&show=members&profile='.$member['member_id'])."	".LinkInternal('Edit','?op=rudi&show=members&service='.$member['member_id'])."	".LinkInternal('Edit','?op=rudi&show=members&award='.$member['member_id'])."