PHP/MySQL - Using results of a query to use in another query

Question

I have two tables, one with posts and another one with comments:

posts
-----
ID
user_ID
text
date

comments
--------
ID
post_ID
user_ID
text
date

I want to display every post and for each post, I want to display the related comments. So I made two queries:

include('bdd.php');
$reponse = $bdd->query('
    SELECT posts.ID AS post_ID, posts.user_ID, posts.text, posts.date FROM posts
    ORDER BY posts.ID DESC
');
while ($post = $reponse->fetch()){
    //displaying a post
    $get_comments=$bdd->query('SELECT * FROM comments WHERE post_ID ='.$post['post_ID']);
    while($comment = $get_comments->fecth()){
         //displaying a comment
         echo $comment['text']
    }
}

But the code stops and only displays the first post without the comments.

are you using PDO? Try to insert $reponse->execute(); before first while. OR replace $bdd->prepare(); with $bdd->query(); — Sunil Kumar
– Sunil Kumar, Commented Sep 29, 2013 at 11:09
Yes, you're right, I forgot it when I simplified the code, I just added it. It doesn't solve the problem. Thanks anyway. — Codophage
– Codophage, Commented Sep 29, 2013 at 11:48
No, don't. It doesn't solve the problem, it still doesn't work. Sorry if I wasn't clear enough. — Codophage
– Codophage, Commented Sep 29, 2013 at 11:52
make sure the post your displaying must have some comments on your database.Test your mysql query and loop. your code is ok. use echo $bdd->rowCount(); to check numbers of rows selected — Sunil Kumar
– Sunil Kumar, Commented Sep 29, 2013 at 11:56

Sunil Kumar · Accepted Answer · 2013-09-29 12:06:50Z

2

Try to insert

 $reponse->execute();

before first while. OR replace $bdd->prepare(); with $bdd->query();

Typo error:

$get_comments->fecth() check your fetch() spelling

edited Sep 29, 2013 at 12:06

answered Sep 29, 2013 at 11:51

Sunil Kumar

1,3912 gold badges15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Codophage Over a year ago

It was the spelling mistake. Thank you!

Rajesh · Accepted Answer · 2013-09-29 10:49:57Z

1

is the select query even correct??

SELECT posts.ID AS post_ID, posts.user_ID, posts.text, posts.date
ORDER BY posts.ID DESC

It has no FROM clause. Should have been as below:

SELECT posts.ID AS post_ID, posts.user_ID, posts.text, posts.date FROM posts
ORDER BY posts.ID DESC

answered Sep 29, 2013 at 10:49

Rajesh

3,7781 gold badge26 silver badges33 bronze badges

1 Comment

Codophage Over a year ago

You're right, infact, I simplified the code, and I forgot the FROM. But that's not the problem. Thanks anyway. I added the FROM.

Collectives™ on Stack Overflow

PHP/MySQL - Using results of a query to use in another query

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related