strtotime, Problem to print people born before 1970

stephaneka

Hi, got a little problem
I have a formular for a search query in database.
Actually it's running, i can ask to search people between age but it doesn't print me people who was born before 1970

CODE
$bday_high = date('U',strtotime("-$search_age_from years"));
$bday_low = date('U',strtotime("-$search_age_to years"));

$query = mysql_query("SELECT * FROM bhost_users WHERE gender='$search_looking_for' $avatarrow AND birthday BETWEEN $bday_low AND $bday_high LIMIT $src->toplim,$src->npp") or die(mysql_error()); }

Can i do it with strtotime or need i modify something?

Best regards
Stephane

bpat1434

Depends on what type of format you ahve the birthdays stored in the database as. And also...

Seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

Not sure if you'd get a proper datestamp using that.... perhaps a [man]time/man or [man]mktime/man would help you out...

~Brett

Roger_Ramjet

Another good reason to use the MySQL datetime column type and the inbuilt date functions

datetime couln type
The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. (“Supported” means that although earlier values might work, there is no guarantee)

date and time functions
You can use date_format() in the query to return the stored date in almost any format you can think of. There are all the functions you would expect to extract part of the date or time, functions to manipulate unix timestamps, and str_to_time() to convert most date strings/formats into a mysql datetime data type.

Far easier than doing it in php.