$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’]; } ?> |