php & mysql: How to get values between two dates including both of them

Question

I need to to get values between two dates including both of them. And is it possible to get values of one date if user selects both dates as same?

I have date column as date and time i am using code as :

select * 
from tbl_issue 
where issue_on>='$date_search' 
    and issue_on<='$date_search1' 
    and item_name='$item_id';

$date_search1 = substr($date_search1,8,2).substr($date_search1,4,4).substr($date_search1,0,4);

The result of this i am getting is between these dates but i wants including both of them.

Help!!

Indian · Accepted Answer · 2013-04-11 09:56:23Z

2

You can change your query to this. This will get you the expected result:

select * from tbl_issue where (issue_on between '$date_search' and '$date_search1') and item_name='$item_id';

answered Apr 11, 2013 at 9:56

Indian

1115 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Sadique Hassan Over a year ago

Dear I want both dates to be included and it will not work in case user selects both dates as same.

Sadique Hassan Over a year ago

I want two values of dates 2013-04-01 and 2013-04-10 and this query gets values of 2013-04-01 but not getting values of 2013-04-10 it takes values from 2013-04-01 to 2013-04-09

Indian Over a year ago

Do you want all the data between these 2 dates or you just want data of these 2 dates?

Sadique Hassan Over a year ago

I want data of 2013-04-01 to 2013-04-10 both dates included a

Indian Over a year ago

No, you would be doing some mistake, this query will get you the data from 2013-04-01 to 2013-04-10. Can you echo the query and check what's there in $date_search1?

|

Collectives™ on Stack Overflow

php & mysql: How to get values between two dates including both of them

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related