Display all the dates between 2 separate date column in MYsql

Asked Oct 28 '14 at 06:34

Active Oct 28 '14 at 06:40

Viewed 41 times

how can i display all dates between start_date and end_date according to the place.

for example.
from id 1 the result will be

16-10-2014
17-10-2014
18-10-2014
19-10-2014
20-10-2014
21-10-2014
22-10-2014
my code is not working.
Any help ?
Thank you in advance.

enter image description here

edited Oct 28 '14 at 06:40

SonalPM

asked Oct 28 '14 at 06:34

sameer kumar

So you will pass the id and want to get all the dates in that range ? – Abhik Chakraborty Oct 28 '14 at 06:39
no i like to pass the place to retrieve dates. – sameer kumar Oct 28 '14 at 06:42
in mysql its pretty complicated to do it. Using the application level programming like PHP it will be very easy to do. – Abhik Chakraborty Oct 28 '14 at 06:45
Any suggest how to do in PHP @Abhik Chakraborty – sameer kumar Oct 28 '14 at 07:14
check here how to generate the dates between 2 dates in PHP http://stackoverflow.com/questions/4312439/php-return-all-dates-between-two-dates-in-an-array – Abhik Chakraborty Oct 28 '14 at 07:16

0 Answers0