$length)
{
// string exceeded length, truncate and add trailing dots
return substr($str,0,$length).$trailing;
}
else
{
// string was already short enough, return the string
$res = $str;
}

return $res;
}

mysql_select_db($database_phone, $phone);
if (!isset($_GET[‘arch’])) {
$query_Recordset1 = “SELECT * FROM customer WHERE MemPaid=1 AND WebShow=1 AND id!=’$_GET[id]’ AND Membership=’$_GET[mem]’ AND Board=’$_GET[brd]’ OR Board=’$_GET[bod]’ AND WebShow=1 AND id!=’$_GET[id]’ ORDER BY Last_Name, FIrst_Name ASC”;
} else {
$query_Recordset1 = “SELECT * FROM customer”;
}
$Recordset1 = mysql_query($query_Recordset1, $phone) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_select_db($database_phone, $phone);
if (!isset($_GET[‘arch’])) {
$query_Recordset2 = “SELECT * FROM customer WHERE id=$_REQUEST[id]”;
} else {
$query_Recordset2 = “SELECT * FROM customer”;
}
$Recordset2 = mysql_query($query_Recordset2, $phone) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

?>

“; echo $row_Recordset2[‘address2’]; }
echo “
“; echo $row_Recordset2[‘City’]; echo “, “; echo $row_Recordset2[‘Province’];
echo “
“; echo $row_Recordset2[‘PC’];
echo “
“; echo $row_Recordset2[‘Country’];
if ($row_Recordset2[‘locate’] != ”) { ?>

Google Maps Directions
“; ?>
E-mail:“; }
if ($row_Recordset2[’email2′] != ”) { echo “
“; }
if ($row_Recordset2[‘Phone_HM’] != ”) { echo “
Home Phone:“; }
if ($row_Recordset2[‘cell’] != ”) { echo “
Cell Phone:“; }
if ($row_Recordset2[‘Phone_BU’] != ”) { echo “
Bus. Phone:“; }
if ($row_Recordset2[‘phonex’] != ”) { echo “
“; echo $row_Recordset2[‘phonexname’]; echo ” Phone:“; }
if ($row_Recordset2[‘Fax’] != ”) { echo “
Fax Number:“; }
?>
“; echo $row_Recordset2[‘Email’]; echo ““; } if ($row_Recordset2[’email2′] != ”) { echo “
“; echo $row_Recordset2[’email2′]; echo ““; } if ($row_Recordset2[‘Phone_HM’] != ”) { echo “
“; echo $row_Recordset2[‘Phone_HM’]; } if ($row_Recordset2[‘cell’] != ”) { echo “
“; echo $row_Recordset2[‘cell’]; } if ($row_Recordset2[‘Phone_BU’] != ”) { echo “
“; echo $row_Recordset2[‘Phone_BU’]; } if ($row_Recordset2[‘phonex’] != ”) { echo “
“; echo $row_Recordset2[‘phonex’]; } if ($row_Recordset2[‘Fax’] != ”) { echo “
“; echo $row_Recordset2[‘Fax’]; } ?>



&&mem=member&brd=no&bod=yes”>Members | Name
Home Phone
E-mail Address

bgcolor=”#DFEAF6″ >