geatzo

$limit = isset($_SESSION['records-limit']) ? $_SESSION['records-limit'] : 5; $page = (isset($_GET['page']) && is_numeric($_GET['page']) ) ? $_GET['page'] : 1; $paginationStart = ($page - 1) * $limit; $authors = $db->query("SELECT * FROM posts LIMIT $paginationStart, $limit")->fetchAll(); // Get total records $sql = $db->query("SELECT count(id) AS id FROM posts")->fetchAll(); $allRecrods = $sql[0]['id']; // Calculate total pages $totoalPages = ceil($allRecrods / $limit); // Prev + Next $prev = $page - 1; $next = $page + 1; trying to add a where to the first select $authors = $db->query("SELECT * FROM posts WHERE username = ? LIMIT $paginationStart, $limit")->fetchAll(); $result = $pdo->prepare($authors); $result->execute([$row2['username']]); but im getting a error if anyone can help?

so $stmt2m2 = $db->prepare('SELECT * (DISTINCT recipient_username) FROM messages WHERE recipient_username = ? LIMIT 4 '); My data is posted in the first post

?> <script type="text/javascript"> window.location.href = 'http://www.google.com.au/'; </script> <?php This does not make the headers work but its a work around.

The part im stuck on is displaying all the users who messaged so lets say i have 2 mails from user1 and 1 mail; from user 2 my coding will show all 3 mails. What i need is for my coding to show 2 mails because of course there are 2 users mailing me not 3 ( even tho there are 3 results) i hope this makes sense. So i simply trying to find a way to display the users who mailed me but at the moment its showing user1 user1 user2 instead i need it to show user1 user2 its showing user1 twice because there are 2 messages from user 1

Im trying to make a php message script i can output the message's but im having a issue with grouping them Here is a photo of the html https://prnt.sc/WtJhNnteYaq1 But im outputting the message's and if the same person sends 2 message's it shows has separate https://prnt.sc/xSAIT9cQlHt3 I can ether just output all the from usernames on the left side then when the user clicks a chat head the messege will do a simple search where that username but again it will show muti chat heads for the same users Here is my table https://prnt.sc/0hRyCNozTlpZ $stmt2m2 = $db->prepare('SELECT * FROM messages WHERE recipient_username = ? LIMIT 4 '); $stmt2m2->execute( array($_SESSION['username'] ) ) ; $row2m2 = $stmt2m2->fetchAll(); foreach($row2m2 as $users2) { ?> <a href="#" class="media"> <div class="item-img"> <img src="media/figure/notifiy_1.png" alt="Notify"> </div> <div class="media-body"> <h6 class="item-title"><?php echo $users2['sender_username'] ; ?></h6> <div class="item-time"><?php echo $users2['date'] ; ?></div> <p><?php echo $users2['message'] ; ?></p> </div> </a> <?php } ?>