PHP - Finding Age From Birthdate

I thought I'd never have to ask another date related question after the help I got from Pikachu earlier this month but I can't get this simple thing to work.
I have a table post for Date of Birth (Format YYYY-MM-DD) and a search form where you select From and To Numbers to find users between these ages.

I have tried a few different things - this one works best, if I choose from any number and up til current time I get results but as soon as I set the script to use the selected variable I bomb. Also, somehow I got the script to only return the users with a DOB of 0000-00-00.

Here is the current version (shortened to show the relevant parts):

Code: [Select]
$now = time(); //current timestamp
$now=(date("Y-m-d"));

if (isset($_POST['ageFr']))  //sets the stopdate for the search
$ageFr = sanitizeString($_POST['ageFr']);
$yearStop="date_sub($now, INTERVAL $ageFr YEAR)";

if (isset($_POST['ageTo']))  //sets startdate for the same search
$ageTo = sanitizeString($_POST['ageTo']);
$yearStart="date_sub($now, INTERVAL $ageTo YEAR)";


$query = "SELECT * FROM user_criteria WHERE sex='$sex' AND (age BETWEEN ($yearStart) AND ($yearStop))"; //The query


When I echo like this:
echo "$ageFr to $ageTo <br />";
echo "$yearStart - $yearStop";
echo "<br /> $query";

I get this:
18 to 101
date_sub(2012-01-24, INTERVAL 101 YEAR) - date_sub(2012-01-24, INTERVAL 18 YEAR)
 SELECT * FROM user_criteria WHERE sex='Female' AND (age BETWEEN (date_sub(2012-01-24, INTERVAL 101 YEAR)) AND (date_sub(2012-01-24, INTERVAL 18 YEAR)))

Shouldn't that work? Am I making a big or a small mistake here? Pikachu? 

I have an advanced search from that has 20 fields and it works great however I'm having a problem with customising the age range search based on the $birthdate field (YYYY/MM/DD). The user inputs $agefrom and $ageto and then I don't know how to convert the birthdate field to an age to be able to echo only the users in that age range...
 

<?php
$cQuery = 'true and ';
$aSearchcriteria = array();

//more code here...(other search input that works)

if(isset($_POST['agefrom']) and trim($_POST['agefrom'])  and strip_tags ($_POST['agefrom']) and mysql_real_escape_string ($_POST['agefrom'] ))
if(isset($_POST['ageto']) and trim($_POST['ageto'])  and strip_tags ($_POST['ageto']) and mysql_real_escape_string ($_POST['ageto'] )) {
             
  $cQuery .= "$birthdate BETWEEN '$agefrom' AND '$agefrom' and ";
  $aSearchcriteria[] = $agefrom;
  $aSearchcriteria[] = $ageto; 
}

//more code here...(other search input that works)

$data = mysql_query("SELECT * FROM table WHERE $cQuery order by name, surname") or die("SELECT Error: ".mysql_error());

// more code here

// table echo here...
?>

How can I build a form with a drop down menu with the year, day, month?  And then send that information to a database.

If there is another/better option besides a drop down menu?  If so, please tell me.

The rest of the form is working fine, and all the inforamtion is going to the database - last name, first name, address, phone number, zip code, race,,,,,,,,,.

 I work for a not-for-profit medical office - we provide medical services to the local people who can not afford to go to a regular doctor.  We need a simple way to keep track of patient information.  One of the things we need to enter is the birthdate. 

Searching the forums provided a lot of results, but the words date and form are used so much, I can not find anything that helped me.  I also looked through php.net, but can not find anything there.

Hi

I have a file, that is copied from other files. All other files work perfectly.
But, for some reason this one is throwing back an error.

I've been over it so many time, but can't see whats wrong.

Error:
Fatal error: Call to undefined method stdClass::save() in /home/p/o/powtest/web/public_html/admin/lib/ajax_php/add_interests.php on line 28


add_interests.php
Code: [Select]
<?PHP
require_once("../../../includes/initialize.php");

$flag = 0;
$ID = $_POST['ID'];
$type = $_POST['type'];
$category = $_POST['category'];
$interest = $_POST['interest'];
$expInt = explode("\n", $interest);
$DMOD = date('Y-m-d');
$TMOD = date('H:i:s');

$check_entry = Admin_interest::if_exists(clean_input_value($category));
if($check_entry == 0){
$new_category = Admin_interest::make($ID, clean_input_value($category), clean_input_value($type), $DMOD, $TMOD);
if($new_category && $new_category->save()){
$CID = $new_category->id;
$flag = 1;
}
}


foreach($expInt as $expInts){

$check_entry = Admin_interests_sub::if_exists($CID, clean_input_value($expInts));
if($check_entry == 0){
$new_interest = Admin_interests_sub::make($ID, $CID, clean_input_value($expInts), $DMOD, $TMOD);
if($new_interest && $new_interest->save()){
$message = 'Thank You: Your list Has Been Saved';
}else{
$message = "Sorry, There was an error";
}
}

}

echo $message;
?>


Class:
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Admin_interests_sub {

protected static $table_name="admin_interests_sub";
protected static $db_fields = array('id', 'category_id', 'interest_sub', 'dateMod', 'timeMod');
public $id;
public $category_id;
public $interest_sub;
public $dateMod;
public $timeMod;


public static function make($ID, $category_id, $interest_sub, $DMOD, $TMOD){
if(!empty($interest_sub)){
$interest = new Admin_interests_sub();
$interest->id = (int)$ID;
$interest->category_id = (int)$category_id;
$interest->interest_sub = $interest_sub;
$kw->dateMod = $DMOD;
$kw->timeMod = $TMOD;
return $kw;
}else{
return false;
}
}

protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

}

?>


Any help finding this bug will be a big help.

Thanks

Okay I'm done with searching for answers, working on this preg_match for about 3 hours now.   I'm looking for "($0.01/$0.02 USD)" in a string. The needle might be slighty different. Possible strings that I might look for is:

(€xx.xx/€xx.xx EUR) where the EUR can be changed into USD, including its signs.