Im trying to create a simple forum uusing a mysql database,
Here is a list of my topics,
http://coronadoshores.ca/community/
Heres the post in 1 of those topics,
http://coronadoshores.ca/community/category.php?id=1&topic=Welcome
if you click on the replies link it shows; the post, as well as both of its replies,
http://coronadoshores.ca/community/post.php?id=3
I want to target the 1st record in that query
SELECT mess.subject, mess.message_txt, mess.mess_id, mess.parent_id, mess.created, users.name
FROM messages AS mess
INNER JOIN `users`
ON users.id = mess.user_id
WHERE mess.parent_id = :id
OR mess.mess_id = :id
GROUP BY mess.created
so I can style the post like it is in the category page (and only have the replies be blockquotes
while($row = $stmt->fetch()) {
echo "<blockquote><h3>{$row['subject']}</h3><p>".$row['message_txt']."</P>";
echo "<footer class='pull-right'>".$row['name']." on ".$row['created']."</footer>";
echo "</blockquote>";
}