Show comments of specific news article using php.

Question

I need help guys. I want to show the comments of a specific news article. I have a table for comments and one for news. I added a news_id column in the comments table, which corresponds to the id of the article in the news table. How do I go about this?

(procedure of doing it in codeigniter would be best but any other is wrlcomed).

Answer 1

i dont know if i understand your question, but i thing your sql code should be something like this:
select n.article from comments as c, news as n where c.news_id = n.id

Answer 2

please give me more information. or show me the code you wrote with the result and an example of your tables

Answer 3

no i dont

Answer 4

if i could help you it would be nice if you post your way to solve the problem, or upvote the post which helps to find out your solution

Answer 5

@Oliver, you've understood it well. I tried using that but I still got the same comments for different news articles. What might be wrong?

Answer 6

Sorry for delay. do u use codeigniter? ?

Answer 7

mmm, its a bit tough then coz its wat I use. let me try to cut out the clutter.

Answer 8

hey @Oliver I've solved it. Thanks for ē help anyway

Answer 9

@Oliver, it was sth to do with how I was handling the data in codeigniter. I had to set the news id, and pass it into the model and the view.

But thanx for ur answer really, it reminded me of sm things.

Answer 10

Muito Bom