Steynsk
asked on
Age counter only counting years
Hi experts,
In my site I've got two age counters in a loop but they only count the years.
For example someone with birth date 2003-9-30 will be precented as a 7 years old person.
But he should be precented as a 6 year old. What should I change in my current code set this right?
Thanks
In my site I've got two age counters in a loop but they only count the years.
For example someone with birth date 2003-9-30 will be precented as a 7 years old person.
But he should be precented as a 6 year old. What should I change in my current code set this right?
Thanks
<?php
if(!isset($_POST['team'])){header("Location: samenstellen_keuze.php");}
include('../includes/config.php');
access_control();
if(isset($_GET['moveto'])){$type = $_GET['moveto'];
if ($type == "right"){
if(isset($_POST['moveright'])){
$moveright_array = $_POST['moveright'];
foreach($moveright_array as $value1){
$sql="INSERT INTO functies (functietype, groepsID, persoonsID) VALUES ('41', '{$_POST['team']}', '$value1')";
$Result1 = mysql_query($sql,$con)or die(mysql_error());
}
unset($_POST['moveright']);
}
}
if ($type == "left"){
if(isset($_POST['moveleft'])){
$moveleft_array = $_POST['moveleft'];
foreach($moveleft_array as $value2){
mysql_select_db($database, $con);
$sql="delete from functies where functietype = '41' AND groepsID = '{$_POST['team']}' AND persoonsID = '$value2'";
$Result1 = mysql_query($sql,$con)or die(mysql_error());
}
unset($_POST['moveleft']);
}
}
}
$sql = "SELECT id, naam FROM groepen where id=". $_POST['team'];
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs)
?>
<html>
<head>
<link rel='stylesheet' href='../tree1.css'>
</head>
<body>
<form name="samenstellen" method="post" action="samenstellen.php?moveto=right">
<table align="center" border=0>
<tr><td colspan=3 align="center"><h3>Team indelingen</h3></td></tr>
<?
if(isset($_POST['leeftijdvan']) && $_POST['leeftijdtot'] != "") {
echo "<tr><td align=\"center\"><b>Leden database <font size=1>(gefilterd van ". $_POST['leeftijdvan']. " jaar tot ". $_POST['leeftijdtot']." jaar)<br>Minus de leden die al aan teams zijn toegewezen</font></b></td><td></td><td align=\"center\"><b>Team : ". $row['naam'] ."</b></td></tr>";
}else{
echo "<tr><td align=\"center\"><b>Leden database <font size=1>(Geen filter op leeftijd)<br>Minus de leden die al aan teams zijn toegewezen</font></b></td><td></td><td align=\"center\"><b>Team : ". $row['naam'] ."</b></td></tr>";
}
?>
<tr>
<td>
<select style="width: 300px; overflow:auto;" multiple="multiple" SIZE="40" name="moveright[]">
<?php
if(isset($_POST['leeftijdvan']) && $_POST['leeftijdtot'] != "") {
$sql="SELECT * FROM personen WHERE str_to_date(geboortedatum,'%Y-%m-%d') <= date_add(CURDATE(), INTERVAL -".$_POST['leeftijdvan']." YEAR) and str_to_date(geboortedatum,'%Y-%m-%d') > date_add(CURDATE(), INTERVAL -1 -".$_POST['leeftijdtot']." YEAR) AND ID not in (select persoonsID from functies where functietype = '41') order by achternaam";
}else{
echo "geen filter";
$sql="SELECT * FROM personen WHERE ID not in (select persoonsID from functies where functietype = '41') order by achternaam";
}
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
if (!($row['geboortedatum'] == "")){
$arrDate = explode('-', $row['geboortedatum']);
//$timestamp = mktime( 0 , 0 , 0 , $arrDate[1], $arrDate[2], $arrDate[0]);
$jaren= date( "Y" ) - $arrDate[0];
echo "<option value=\"".$row['id']."\">".$row['achternaam'].", ". $row['voornaam']." ". $row['tussenvoegsel']. " (". $jaren. " Jaar) ".$row['geboortedatum']."\n ";
}else{
echo "<option value=\"".$row['id']."\">".$row['achternaam'].", ". $row['voornaam']." ". $row['tussenvoegsel']."\n ";
}
}
?>
</select>
</td><td>
<input name="submit" type="submit" value="Voeg toe >" /><br>
<input type=hidden value="<? echo $_POST['team']; ?>" name="team" id="team">
<input type=hidden value="<? echo $_POST['leeftijdvan']; ?>" name="leeftijdvan" id="leeftijdvan">
<input type=hidden value="<? echo $_POST['leeftijdtot']; ?>" name="leeftijdtot" id="leeftijdtot">
</form>
<form name="samenstellen" method="post" action="samenstellen.php?moveto=left">
<input name="submit" type="submit" value="< Verwijder" /></td>
<td>
<select style="width: 300px; overflow:auto;" multiple="multiple" SIZE="40" name="moveleft[]">
<?php
$sql = "SELECT personen.id, voornaam, tussenvoegsel, achternaam, geboortedatum FROM personen INNER JOIN functies ON personen.id = functies.persoonsID WHERE functies.groepsID ='".$_POST['team']."' AND functies.functietype = '41' ORDER BY achternaam";
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
if (!($row['geboortedatum'] == "")){
$arrDate = explode('-', $row['geboortedatum']);
//$timestamp = mktime( 0 , 0 , 0 , $arrDate[1], $arrDate[2], $arrDate[0]);
$jaren= date( "Y" ) - $arrDate[0];
echo "<option value=\"".$row['id']."\">".$row['achternaam'].", ". $row['voornaam']." ". $row['tussenvoegsel']. " (". $jaren. " Jaar) ".$row['geboortedatum']."\n";
}else{
echo "<option value=\"".$row['id']."\">".$row['achternaam'].", ". $row['voornaam']." ". $row['tussenvoegsel']."\n";
}
}
?>
</select>
<input type=hidden value="<? echo $_POST['team']; ?>" name="team" id="team">
<input type=hidden value="<? echo $_POST['leeftijdvan']; ?>" name="leeftijdvan" id="leeftijdvan">
<input type=hidden value="<? echo $_POST['leeftijdtot']; ?>" name="leeftijdtot" id="leeftijdtot">
</td></tr>
<tr><td align="center" colspan=3><INPUT type="button" value="Terug" onClick="location.href='../../beheer/verkeersplein.php'"><INPUT type="button" value="Een ander team kiezen" onClick="location.href='samenstellen_keuze.php'"></td></tr>
</table>
</form>
</body>
</html>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome, it's a great question -- thanks for the points! ~Ray
ASKER