SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: mysql query

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Feb 2001
    Posts
    20
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    only count unique items

    is it possible to do a mysql query where it will only count a unique item

    so if there is 2 of the same in the table, it will only count the first one, and skip the rest

    thanks
    Last edited by undecided; Feb 14, 2001 at 00:07.
    ___________________________________

    << Footer under construction >>

  2. #2
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think you need to put the word DESTINCT in there somewhere. Not exactly sure where it goes in the query but I'm pretty sure that is what you need

  3. #3
    SitePoint Guru
    Join Date
    Jan 2001
    Location
    Alkmaar, Netherlands
    Posts
    710
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you have accent I think
    it is DISTINCT


Bookmarks

Posting Permissions

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