Hi there I want to fetch record Between to dates

Question

I want to fetch records from the DB from one date to the second I have to fetch records but it's not giving me a record of the last date.

$query =  "SELECT `date_of_info_added` , `sub_source` FROM `jcontacts` where date_of_info_added  >= $month and date_of_info_added <= $end ORDER BY date_of_info_added DESC";

[Does this answer your question?](https://stackoverflow.com/questions/8458290/mysql-select-data-from-database-between-two-dates) — Definitely not Rafal, Jan 14 '21 at 10:23
What are the actual contents of $month and $end? (Also: you may want to consider using the BETWEEN...AND operator. It is not really functionally different, but IMHO way more readable) https://www.techonthenet.com/mysql/between.php — Hartmut Holzgraefe, Jan 14 '21 at 10:24
$month = strtotime($start."-01-01"); $end = strtotime($end."-12-31"); — Junaid Ameen, Jan 14 '21 at 10:25
These are two variable i am trying to get the record of the whole year — Junaid Ameen, Jan 14 '21 at 10:25

score 0 · Answer 1 · answered Jan 14 '21 at 10:27

0

Can you try this... use between.

$query = "SELECT date_of_info_added , sub_source FROM jcontacts WHERE date_of_info_added BETWEEN '$month' AND '$end' ORDER BY date_of_info_added DESC"

answered Jan 14 '21 at 10:27

Rain Lai

9
1
3

$month = strtotime($start."-01-01"); $end = strtotime($end."-12-31"); Actually it's not giving me the record of 31 Dec date – Junaid Ameen Jan 14 '21 at 10:32
where is the year from your sample? what is the value of $month and $end? – Rain Lai Jan 14 '21 at 10:46
I didn't use year its working fine without year but not giving me the data of 31 dec – Junaid Ameen Jan 14 '21 at 10:48
another way is you might want to add time for the end.... $end = $end." 23:59:59"; or the latest time you want based on now. – Rain Lai Jan 14 '21 at 10:51

Hi there I want to fetch record Between to dates

1 Answers1