how to sort post titles under their correct category names PHP and SQL

debugcn Published at Dev

Ryan

I have searched for about 4 hours today on how to do this. I want to pull all post titles and categories from the posts table and essentially want to list the "Funny" category and then list all post that have the funny category under that category. Right now I am getting the following: Funny -post title Funny -post title I want to output Funny -post title -post title

    <?php
$query = "SELECT post_category,post_title FROM posts ";
$select_categories_sidebars = mysqli_query($connection, $query);
?>
<h4>Blog Categories</h4>
<div class="row">
<div class="col-lg-12">
<ul class="list-group">
<?php
while($row = mysqli_fetch_assoc($select_categories_sidebars)) {
$post_title = $row['post_title'];
$post_tags = $row['post_category'];
echo "<li class='list-group-item'>$post_tags</li><ul>";
echo "<li class='list-group-item'><a href='category.php?category=$post_title'> {$post_title}</a></li></ul>";
}
?>
</ul>

Ryan

Well I basically got it working how I want I just need to format it correctly now, but it is working with some help from this question. PHP Group sql query under the same title

<?php

            $query = "SELECT post_category,post_title FROM posts ORDER BY post_tags";
            $select_categories_sidebars = mysqli_query($connection, $query);

            ?>


            <h4>Blog Categories</h4>
            <div class="row">
                <div class="col-lg-12">
                    <ul class="list-group">
                        <?php
                        $title = "";
                        while ($row = mysqli_fetch_array($select_categories_sidebars)) {
                            if ($row['post_category'] != $title) {
                                echo '<li class="list-group-item">'.$row['post_category'].'</li><br>';
                                $title = $row['post_category'];
                            }
                            echo '<li class="list-group-item">'.$row['post_title'];
                        }

                        ?>

Collected from the Internet

Please contact [email protected] to delete if infringement.