sql query to display all days Exist between two date from database

Question

Tablename - Receipt

   coupondate    name      recno
   15-04-2015     A          1
   15-05-2015     A          1
   15-06-2015     A          1
   15-07-2015     A          1
   15-08-2015     A          1
   15-09-2015     A          1

FOR EX - Expected output

Days  15-04 16-04 17-04 18-04 19-04 20-04 21-04.....like wise upto 15-09
 A     P     P     P     P     P      P     P                        P

to display all days within selected date.

<?php
$startdate = $_POST['fromdate'];
$enddate = $_POST['todate'];
$start = date('d', strtotime($startdate));
$end=date('d', strtotime($enddate));
?>

<?php   for ($x = $start; $x <= $end; $x++) { ?>
    <th width="58%"><?php echo $x; ?></th>
<?php } ?>

below code to display P Else NULL

<?php if($row['coupondate'] == $x) { ?>
        <td>P</td>
        <?php }  else { ?>
        <td>NULL</td>

Now i cannot understand here how to display P if coupondate matched with $x date..

for ex - coupondate starts from 15-04 and end on 15-09 ok..

now i need to display P below to this customer from 15-04 upto 15-09

Please, post an sqlfiddle link with sample data and a query, you tried to solve the problem — user4035, May 18 '15 at 11:18
Note that dates in SQL adhere to a specific format, but beyond that this is just a simple question about data display. You would handle that in your application level code (php), with a simple loop. There's no point posting a sqlfiddle for this. It's not an sql problem. — Strawberry, May 18 '15 at 11:20
i know how to generate days but the problem i need to get min and max coupondate in query without any condition and also need to display P below all days.. — ankit ingle, May 18 '15 at 11:42
plz see my edited question and suggest proper solution as i want...plz... — ankit ingle, May 18 '15 at 12:37

score 0 · Answer 1 · edited May 23 '17 at 12:15

0

See this:

generate days from date range

edited May 23 '17 at 12:15

Community

1
1

answered May 18 '15 at 11:27

Pathik Vejani

4,263
8
57
98

i know how to generate days but the problem i need to get min and max date in query and also need to display P below all days.. – ankit ingle May 18 '15 at 11:41
you can use min and max function – Pathik Vejani May 18 '15 at 12:18

sql query to display all days Exist between two date from database

1 Answers1