I want to show the month name at the beginning of each month, along with the products

1/14/2020 9:19 am | #1 Jonas

I have a result page from a product database, where I want to list the products in date order. I also want to show the month name at the beginning of each month. The table contains the following columns: ProductID, ProductMonth, ProductDate, ProductName. How do I write this query?

1/14/2020 9:30 am | #2 Ray BorduinWebAssist

I don't really understand the question. I think the query would just be:

SELECT * FROM products ORDER BY ProductDate

Then just write the month name at the beginning of each month like:

php:

<?php

$lastMonth = "";

?>

<?php

while (!$recordset->atEnd()) {

?>

<?php

if ($lastMonth != $recordset->getColumnVal("ProductMonth")) {

?>

<h2><?php echo($recordset->getColumnVal("ProductMonth")); ?></h2>

<?php

  $lastMonth = $recordset->getColumnVal("ProductMonth");

}

?>

<!-- rest of your looped code here -->

Did this help? Tips are appreciated...

1/14/2020 11:47 am | #3 Jonas

I think you understood! But I don't make it work. The page is empty (http error).
Attaches image to code and how it should look like (static code).

Attached Files

aktuella-provningar.php

1/15/2020 8:06 am | #5 Jonas

Thanks, now it's getting closer!
The name of the month is now displayed only for the first product within the same month.
But at the same time, it seems that this table row, with the month name - appears under all products - which is obviously not good.
The attached screen shows these lines that I marked with red color (in css).

How do I make this row appear only with the month name?

Attached Files

aktuella-provningar.php

1/15/2020 9:50 am | #6 Ray BorduinWebAssist

You have:

php:

<?php if ($RSProvningar->getColumnVal("ProvningManad") !="") { ?><tr class="manadsnamn">

                  <td colspan="4" >

<?php if ($lastMonth != $RSProvningar->getColumnVal("ProvningManad")) { ?>

<h2><?php echo($RSProvningar->getColumnVal("ProvningManad")); ?></h2>

<?php $lastMonth = $RSProvningar->getColumnVal("ProvningManad"); } ?>

                  </td>

                </tr> <?php } ?>

You probably just want:

php:

<?php 

if ($lastMonth != $RSProvningar->getColumnVal("ProvningManad") && $RSProvningar->getColumnVal("ProvningManad") !="") { 

?>

<tr class="manadsnamn">

  <td colspan="4" >

<h2><?php echo($RSProvningar->getColumnVal("ProvningManad")); ?></h2>

  </td>

</tr>

<?php 

$lastMonth = $RSProvningar->getColumnVal("ProvningManad"); 

} 

?>

Did this help? Tips are appreciated...

1/15/2020 1:25 pm | #7 Jonas

You're right, as always. I learn new things all the time, thank you! One last question about this. Is it possible to make a separate table per month? See attached screenshot. Where the first line is the name of the month. The next line is the table head and then all the products for that month.

Attached Files

aktuella-provningar.php

1/15/2020 3:19 pm | #10 Ray BorduinWebAssist

Try using this for your table:

php:

<?php $lastMonth = "";?>

<?php

$wa_startindex = 0;

while(!$RSProvningar->atEnd()) {

  $wa_startindex = $RSProvningar->Index;

?>

<?php if ($lastMonth != $RSProvningar->getColumnVal("ProvningManad") && $RSProvningar->getColumnVal("ProvningManad") !="") { ?>

<?php 

if (isset($tableShown)) {

echo("</tbody></table>");

}

$tableShown = true;

?>

            <table class="table table-hover">

              <thead>

                <tr>

                  <th scope="col"><i class="far fa-calendar-alt"></i></th>

                  <th scope="col"><i class="fas fa-chair"></i></th>

                  <th scope="col"><i class="fas fa-wine-glass-alt"></i></th>

                  <th scope="col"><i class="fas fa-coins"></i></th>

                </tr>

              </thead>

      

              <tbody>

                <tr class="manadsnamn">

                    <td colspan="4">

                    <h2><?php echo($RSProvningar->getColumnVal("ProvningManad")); ?></h2>

                    </td>

                </tr>

                <?php $lastMonth = $RSProvningar->getColumnVal("ProvningManad");} ?>

                 

                  <tr class="text-black-50">

                    <td><?php echo($RSProvningar->getColumnVal("Dayname")); ?> <?php echo($RSProvningar->getColumnVal("Day")); ?> <?php echo($RSProvningar->getColumnVal("Month")); ?></td>

                    <td><?php echo($RSProvningar->getColumnVal("ProvningPlatser")); ?> st</td>

                    <td><?php echo($RSProvningar->getColumnVal("Kategorier_KategoriNamn")); ?></td>

                    <td><?php echo($RSProvningar->getColumnVal("KategoriPrisklass")); ?></td>

                  </tr>

<?php 

if (1==0) {

  ?>

          </tbody>

        </table>

<?php

}

?>

                  <?php

  $RSProvningar->moveNext();

}

$RSProvningar->moveFirst(); //return RS to first record

unset($wa_startindex);

unset($wa_repeatcount);

?>

<?php 

if (isset($tableShown)) {

echo("</tbody></table>");

}

?>

Did this help? Tips are appreciated...

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

I want to show the month name at the beginning of each month, along with the products

1/14/2020 9:19 am | #1 Jonas