$line2Number = -1;
$totalMembers = mysql_query("SELECT COUNT(*) AS totalMembers FROM management WHERE manPos = '1' ORDER BY name");
$totalMembers = mysql_fetch_array($totalMembers);
$totalMembers = $totalMembers['totalMembers'];
$info = mysql_query("SELECT * FROM management WHERE manPos = '1' ORDER BY name");
$bottomLine = '';
$nextCheck = mysql_query("SELECT COUNT(*) AS totalMembers FROM management WHERE manPos = '2'");
if ($nextCheck = mysql_fetch_array($nextCheck)) {
if ($nextCheck['totalMembers'] > 0) $bottomLine = '
';
if ($nextCheck['totalMembers'] < $totalMembers) $line2Number = $totalMembers;
}
while($row = mysql_fetch_array($info)) {
if ($row['email'] != '') $img = '

';
else $img = '

';
if ($row['manImg'] != '') echo '
'.$img.'
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
'.$bottomLine.'
';
else echo '
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
'.$bottomLine.'
';
}
?>
$line3Number = -1;
$totalMembers = mysql_query("SELECT COUNT(*) AS totalMembers FROM management WHERE manPos = '2' ORDER BY name");
$totalMembers = mysql_fetch_array($totalMembers);
$totalMembers = $totalMembers['totalMembers'];
$info = mysql_query("SELECT * FROM management WHERE manPos = '2' ORDER BY name");
$bottomLine = '';
$nextCheck = mysql_query("SELECT COUNT(*) AS totalMembers FROM management WHERE manPos = '3'");
if ($nextCheck = mysql_fetch_array($nextCheck)) {
if ($nextCheck['totalMembers'] > 0) $bottomLine = '
';
if ($nextCheck['totalMembers'] < $totalMembers) $line3Number = $totalMembers;
}
$check = 1;
while($row = mysql_fetch_array($info)) {
if ($check) {
if ($line2Number > 0) echo '
';
else echo '
';
$check = 0;
}
if ($row['email'] != '') $img = '

';
else $img = '

';
if ($row['manImg'] != '') echo '
'.$img.'
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
'.$bottomLine.'
';
else echo '
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
'.$bottomLine.'
';
}
?>
$totalMembers = mysql_query("SELECT COUNT(*) AS totalMembers FROM management WHERE manPos = '3' ORDER BY name");
$totalMembers = mysql_fetch_array($totalMembers);
$totalMembers = $totalMembers['totalMembers'];
$info = mysql_query("SELECT * FROM management WHERE manPos = '3' ORDER BY name");
$check = 1;
while($row = mysql_fetch_array($info)) {
if ($check) {
if ($line3Number > 0) echo '
';
else echo '
';
$check = 0;
}
if ($row['email'] != '') $img = '

';
else $img = '

';
if ($row['manImg'] != '') echo '
'.$img.'
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
';
else echo '
'.$row['name'].'
'.stripslashes($row['title'.$langAppend]).'
';
}
?>