lostprophetpunk Posted August 29, 2008 Share Posted August 29, 2008 I had finally got round to finishing most of my blog system, but there is one important feature that is missing from it, a comment system. I have set up the following comments table in my phpmyadmin program... comment_id name email comment In my articles table I have the following... article_id article_name entry poster date time editpost Is there any way I can link both the tables, and how would I go about doing this and setting up so that the relevant comments to the relevant articles. I really need help on this as this has been confusing me for ages. Link to comment https://forums.phpfreaks.com/topic/121833-comment-system/ Share on other sites More sharing options...
waynew Posted August 29, 2008 Share Posted August 29, 2008 I had finally got round to finishing most of my blog system, but there is one important feature that is missing from it, a comment system. I have set up the following comments table in my phpmyadmin program... comment_id name email comment In my articles table I have the following... article_id article_name entry poster date time editpost Is there any way I can link both the tables, and how would I go about doing this and setting up so that the relevant comments to the relevant articles. I really need help on this as this has been confusing me for ages. Make the comment table look like so: comment_id article_id name email comment Then for each comment that is posted, enter the article number with it. Then on any given article, just output the comments with that article id number. Link to comment https://forums.phpfreaks.com/topic/121833-comment-system/#findComment-628584 Share on other sites More sharing options...
waynew Posted August 29, 2008 Share Posted August 29, 2008 Look up the ER model. Link to comment https://forums.phpfreaks.com/topic/121833-comment-system/#findComment-628585 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.