Problem calculating age
Posted: Thu Aug 20, 2009 11:41 am
Hi Guys I have the following script in my profile page to calculate the age from yob mob and dob (year, month, day) from the DB
However, the echo from this is: Resource id #11Resource id #12Resource id #131998
when the values in the DB are yob '1979' mob '03' and dob is '14'
Any help or suggestions would be much appreciated, I'm lost!
Code: Select all
//display username
echo "<br>";
$username = mysql_query("SELECT username FROM users WHERE id='$id'");
$firstname = mysql_query("SELECT firstname FROM users WHERE id='$id'");
$gender = mysql_query("SELECT gender FROM users WHERE id='$id'");
$city = mysql_query("SELECT city FROM users WHERE id='$id'");
$birthdate = mysql_query("SELECT birthdate FROM users WHERE id='$id'");
$yob = mysql_query("SELECT yob FROM users WHERE id='$id'");
$mob = mysql_query("SELECT mob FROM users WHERE id='$id'");
$dob = mysql_query("SELECT dob FROM users WHERE id='$id'");
$usernamearray = mysql_fetch_assoc($username);
$firstnamearray = mysql_fetch_assoc($firstname);
$genderarray = mysql_fetch_assoc($gender);
$cityarray = mysql_fetch_assoc($city);
$yobarray = mysql_fetch_assoc($yob);
$mobarray = mysql_fetch_assoc($mob);
$dobarray = mysql_fetch_assoc($dob);
echo $yob;
echo $mob;
echo $dob;
# Function to calculate someone's age
function getage($year,$month,$day) {
# Get current date
$cyear = date('Y');
$cmon = date('m');
$cday = date('d');
# Change day/month to xx format if just x
if(strlen($month) < 2) $month = '0'.$month;
if(strlen($day) < 2) $day = '0'.$day;
# If year is not in xxxx format assume 19xx
if(strlen($year) < 4) $year = '19'.$year;
# Get their age (roughly)
$age = $cyear - $year;
# Account for day/month
if($cmon <= $month && $cday <= $day) {
$age--;
}
return $age;
};
$theirage = getage($yob,$mob,$dob);
echo $theirage;
when the values in the DB are yob '1979' mob '03' and dob is '14'
Any help or suggestions would be much appreciated, I'm lost!