get rows where dob between 2 dates from mysqli

[seany123]

can anyone see why this is not working? or how to make it work? im trying to get all the rows where dob is between

 dob is a date field

<?php
​$todayDate = date("Y-m-d"); 

$minage = date("Y-m-d", strtotime($todayDate . "-18 years"));
$maxage = date("Y-m-d", strtotime($todayDate . "-99 years")); 

$query = mysqli_query($db, "select * from users where `dob` BETWEEN '$minage' AND '$maxage'");

?>

if i replace $minage and $maxage and type in a date manually then it works.

 

 

any help would be great.

 

 

 

 

[Barand]

You need to specify the earlier date of the range first (BETWEEN earlier AND later)

 

You can do it entirely in the SQL

WHERE dob BETWEEN CURDATE() - INTERVAL 99 YEAR AND CURDATE() - INTERVAL 18 YEAR

[seany123]

thanks yeah i worked it out with loads of tinkering.