2023-08-10 00:28:48 +02:00
|
|
|
/*
|
|
|
|
Retreive comments on a story
|
|
|
|
*/
|
2020-08-13 19:59:33 +02:00
|
|
|
SELECT
|
|
|
|
authors.name,
|
|
|
|
comments.isanon,
|
|
|
|
comments.comment_text
|
|
|
|
FROM
|
|
|
|
comments,
|
|
|
|
authors
|
|
|
|
WHERE
|
|
|
|
comments.author = authors.id AND
|
|
|
|
comments.postid = :id
|
|
|
|
ORDER BY post_time DESC;
|