SQL Query to select data between particular date and time dynamically

Question

Kindly provide me SQL query:

We want to select all details from a table where date is equal to particular date and time is between some time period(dynamically).

For example I wish to get all the details of the students where they registered in particular date between particular time.

Answer 1

Try this query:

<?php
$date = date('Y-m-d');
$sql = "SELECT * FROM tbl_stu WHERE reg_date = '$date' AND reg_time >= '$time_1' AND reg_time <= '$time_2'";
?>