include("includes/header.php");
include("includes/scripts.php");
include("portal/includes/db.php");
// Displays alternate table row colors
function row_color($i){
$bg1 = "#EFEFEF"; // color one
$bg2 = "#ffffff"; // color two
if($i%2){return $bg1;}else{return $bg2;}
}
;
$member_type_query = "select * from role where role_id in('02', '03', '04', '05', '09', '10', '11')";
$member_type_result = mysql_query($member_type_query);
?>
Company Directory
| Main Line: |
echo $loc_phone;?>
|
| Fax: |
echo $loc_fax;?>
|
| Email: | echo $loc_email;?> |
| Address: |
echo $loc_address;?> echo $loc_city.', '.$loc_state.' '.$loc_zipcode;?>
|
if(isset($_POST['directory_find'])){
$directory_query = "select distinct a.*, b.role_id, c.role_desc from member a, logon b, role c where a.member_id = b.member_id and b.role_id = c.role_id and a.state_id = '$location' and b.role_id in ('02', '03', '04', '05', '09', '10', '11')";
if(isset($_POST['member_type']) && $_POST['member_type'] != ''){
$directory_query.=" and b.role_id = '".$_POST['member_type']."'";
}elseif(isset($_POST['compare']) && ($_POST['compare'] != '') && (isset($_POST['findtxt']) && $_POST['findtxt'] != '')){
$directory_query.=" and lower(a.".$_POST['member_name'].") ".$_POST['compare']." lower('%".$_POST['findtxt']."%')";
}
$directory_query.=" order by c.role_desc, a.last_name, a.first_name";
$directory_result = mysql_query($directory_query);
?>
|
Name / Title
|
Phone / Email
|
| |
for( $i = 0; $i < $directory = mysql_fetch_array($directory_result); $i++)
{
$member_id = $directory["member_id"];
$first_name = $directory["first_name"];
$last_name = $directory["last_name"];
$middle_name = $directory["middle_name"];
$member_role = $directory["role_desc"];
$phone = $directory["phone"];
$phone2 = $directory["phone2"];
$email = $directory["email"];
$fax = $directory["fax"];
//echo"";
?>
');">
echo"$last_name, $first_name";?> echo"$member_role";?>
|
echo"$phone";?> "> echo"$email";?>
|
}?>
}else{?>
}?>
include("includes/footer.php");?>