include_once "includes/dbConnNew.php";
import_request_variables("gp", "");
if( ($_REQUEST["rndid"] > " ") && ($_REQUEST["invid"] > " ") ){
$SQL = "UPDATE invitations SET Looked = 'Y' WHERE Random_Key = '" . $_REQUEST["rndid"]. "' and ID = '" . $_REQUEST["invid"] . "' ";
$result = mysql_query($SQL) or die(mysql_error());
$_SESSION["sessionRandom_Key"] = $_REQUEST["rndid"];
$_SESSION["sessionInvid"] = $_REQUEST["invid"];
}
header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
$SelectStr = "SELECT DATE_FORMAT(Anniversary, '%M %d, %Y') as Anniv, users.* from users where ID='" . $_REQUEST["fid"] . "'";
$result = mysql_query($SelectStr)or die(mysql_error());
if($myrow=MySQL_fetch_array($result)){
$dob = $myrow["Birth_Date"];
//calculate age
if($dob <> "0000-00-00"){
list($BirthYear,$BirthMonth,$BirthDay) = explode("-", $dob);
$YearDiff = date("Y") - $BirthYear;
$MonthDiff = date("m") - $BirthMonth;
$DayDiff = date("d") - $BirthDay;
if ($MonthDiff < "0"){
$YearDiff --;
} else if ($BirthMonth == date("m") && $DayDiff < "0"){
$YearDiff --;
}
$age = $YearDiff ;
} else {
$age = " " ;
}
$Anniversary = $myrow["Anniv"] ;
if($myrow["Gender"] == "m"){
$sex = "Male" ;
}
if($myrow["Gender"] == "f"){
$sex = "Female" ;
}
}
?>
Yada Home
include 'beforeEndHead.php'; ?>
include "googAna.php"; ?>