"; $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1'"); $num_rows = mysql_num_rows($qq); while($row=mysql_fetch_assoc($qq)){ $i++; $percent = intval($i/$num_rows * 100)."%"; $id = $row['id']; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); mysql_query("UPDATE `talents_profile` SET `age` ='$newAge' WHERE `id`='$id'"); } if($num_rows = $i){ echo "Refreshing Database.... Process ".$percent." Complete.

".$i. " Records has been updated...

"; }else { echo "Refreshing Database....". $percent; } echo "