How can I list data in sections by an ID, with a while loop in PHP? [closed]

by

Order your results by series_id, so all the products with the same value will be together.

$stmt = $pdo->prepare("SELECT series_id, product_name
                       FROM yourTable
                       ORDER BY series_id");
$stmt->execute();

Then when displaying the results, show the Series header and start a new <ul> whenever it changes:

$last_series = null;
echo "<ul>\n";
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    if ($row['series_id'] != $last_series) {
        if ($last_series) {
            echo "</ul></li>\n";
        }
        echo "<li>" . $row['series_id'] . " Series Product\n";
        echo "<ul>\n";
        $last_series = $row['series_id'];
    }
    echo "<li>" . $row['product_name'] . "</li>\n";
}
if ($last_series) {
    echo "</li>\n";
}
echo "</ul>\n";

More Related Contents:

  1. While loop within While loop not looping
  2. Sign in form always showing "Wrong Credentials"
  3. Prevent creating duplicate entries in PHP
  4. php nested while loop. Inner loop works only once [closed]
  5. php/mysql with multiple queries
  6. Query database then email posts from where user is subbed to
  7. PHP Merging Row with same value (more than one column)
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. Fatal error: Call to undefined function mysql_connect()
  10. Having issue with matching rows in the database using PDO
  11. How can I properly use a PDO object for a parameterized SELECT query
  12. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  13. Whether to use “SET NAMES”
  14. Escaping single quote in PHP when inserting into MySQL [duplicate]
  15. How can I get enum possible values in a MySQL database?
  16. Doctrine Query Language get Max/Latest Row Per Group
  17. Inserting data using mysqli
  18. How can I decrypt a password hash in PHP?
  19. Updating from MYSQL to MYSQLI [duplicate]
  20. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  21. PDO error: SQLSTATE[HY000]: General error: 2031
  22. How to display image from database using php [duplicate]
  23. Simple PHP SQL login troubleshooting
  24. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  25. Creating dynamic tables in HTML using MySQL and PHP
  26. Save Accents in MySQL Database
  27. Sort by date (newest)
  28. mysql count occurrences of special character in a field
  29. How to write a stored procedure in phpMyAdmin?
  30. mysql count into PHP variable

Leave a Comment