DB Results Help

Results 1 to 2 of 2

Thread: DB Results Help

  1. #1
    Join Date
    Dec 1969

    Default DB Results Help

    I&#039;m developing a forum system for my employer and what I&#039;m looking to do it make it so a user can click on the total # of posts for a topic and it will list who replied and how may replies they made in they specific topic... kind of like vBulletin Board.<BR><BR>I know how to list the names and how many posts they have but the problem I&#039;m having it making the script not list the same persons name more than once.<BR><BR>IE: A user posts 2 replies under a single topic, it&#039;s displaying that users name 2 times instead of listing it once then skip all other occurrences. Any ideas how to stop it from doing this?

  2. #2
    Join Date
    Dec 1969

    Default RE: DB Results Help

    select UserName, count(postID)<BR>from TableName<BR>group by UserName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts