1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Comments system.

Discussion in 'Web Design & Development' started by challapradyumna, Nov 11, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. challapradyumna

    challapradyumna Thread Starter

    Joined:
    Nov 19, 2010
    Messages:
    370
    I am not into coding a comments system but i want to know how these work.

    Here is my idea of how these work :- You basically create a Comments table with has a ID column which contains the Id of the post at which the comment is posted next the actual comment and then some data about the commenting person . To show the comments under a post we query all the rows that have the id of the post .

    any more ideas????

    If what i think is correct what if the blog becomes super big like lifehacker or gizmodo can the database react fast ??
     
  2. challapradyumna

    challapradyumna Thread Starter

    Joined:
    Nov 19, 2010
    Messages:
    370
  3. colinsp

    colinsp

    Joined:
    Sep 5, 2007
    Messages:
    2,300
    First Name:
    Colin
    You probably have another field in your database that records date & time of the comment so that they are displayed in the correct order or so that you can display the first x and then have a more button to display the rest. To get the query to run quickly if there are a large number of comments you will be into database tuning.
     
  4. challapradyumna

    challapradyumna Thread Starter

    Joined:
    Nov 19, 2010
    Messages:
    370
    Does MySQL have a specific type for filling date??
     
  5. colinsp

    colinsp

    Joined:
    Sep 5, 2007
    Messages:
    2,300
    First Name:
    Colin
  6. TechGuy

    TechGuy Administrator

    Joined:
    Feb 12, 1999
    Messages:
    14,327
    First Name:
    Mike
  7. challapradyumna

    challapradyumna Thread Starter

    Joined:
    Nov 19, 2010
    Messages:
    370
    ^^ Great this solves many other problems also................. Thank you.
     
  8. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1026424

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice