New Memebr List
The following is a list of individuals who have been accepted into Ten-Ten International as new members over the past 45 days.
input->server->get(‘REMOTE_ADDR’,”);
$dt = new DateTime();
$dt1 = $dt->format(‘m/d/Y’);
$dt->modify(‘-45 day’);
$dt2 = $dt->format(‘m/d/Y’);
//echo “Date 1 $dt1“;
//echo “Date 2 $dt2“;
$con = mysqli_connect(“localhost”, “newten_tenadm”, “MNB987@#$”,”newten_tenten”) or die(‘Could not connect to server’); // tenadm
$sql = “SELECT ten,callsign,name,cert FROM `tenmaster` WHERE DATE(str_to_date(cert,’%m/%d/%Y’)) between DATE(str_to_date(‘” .$dt2. “‘,’%m/%d/%Y’)) and DATE(str_to_date(‘” .$dt1 . “‘,’%m/%d/%Y’)) and ten > 77000”;
//echo “$sql“;
$result = mysqli_query($con, $sql);
if ($result){
echo “
| Members in the past 45 days | ||||||
|---|---|---|---|---|---|---|
| Ten-Ten | Call Sign | Name | Date | |||
| ” . $row[‘ten’] . “ | ” . $row[‘callsign’] . “ | ” . $row[‘name’] . “ | ” . $row[‘cert’] . “ | |||
“;
}
?>
