我无法显示在DATE格式化的生日[复制]

Question

This question already has an answer here:

• how to get date between two dates in mysql? 5 answers

i want to display the customers information who was born between 1980 and 1990. And i tried this but it doesnt work. Can u please help me?

This is my php codes.

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "company";


$conn = new mysqli($servername, $username, $password, $dbname)
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM musteri WHERE dogumtarih<'1980-01-01' and 
dogumtarih>'1990-01-01'";
$result = $conn->query($sql);
?>

</div>

Answer 1

Please change your sql between query as per below solutions:

$sql = "SELECT *
FROM musteri
WHERE (dogumtarih BETWEEN '1980-01-01' AND '1990-01-01')";

You can find record between two dates.

Hope This Works for you.