how to return results for an age range in sql?

[spewn]

i have a query i'm running, for people who are between 18 - 24 years old.

here's what i have:

$sth = $dbh->prepare("select * from dbtable where (((TODAYSDATE - uDOB) > 18)&&((TODAYSDATE - uDOB) < 25))");

where TODAYSDATE is a mysql function, and uDOB is my field that stores a the date of birth as YYYY/MM/DD.

any ideas?

- g

 

[travs69]

are you asking how to get the data out of the dbi module or if the SQL is correct?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[max1x]

You should ask this question in the MySQL forum. You can use DEFINE for SELECT statment to check the STMT it's self. Also, I'll have to confirm but the date format in MySQL is YYYY-MM-DD vs xxxx/yy/zz; I've never trying mixing the two.