Professional Web Applications Themes

Eliminating Doubles in SQL - Dreamweaver AppDev

I am developing a ecommerce website. In dreamweaver I have the product categories from the database display as links, my problem is that there is more then 1 product with the same category name and so there are multiple same name categories showing up as links. How do i remove multiples?...

  1. #1

    Default Eliminating Doubles in SQL

    I am developing a ecommerce website. In dreamweaver I have the product
    categories from the database display as links, my problem is that there is more
    then 1 product with the same category name and so there are multiple same name
    categories showing up as links. How do i remove multiples?

    Marsbar24u Guest

  2. #2

    Default Re: Eliminating Doubles in SQL

    Hi Marsha, You could use a SELECT DISTINCT query. The DISTINCT keyword says
    'get all unique values'. So if you did this: SELECT DISTINCT categories FROM
    products That would give you only the unique categories in the products table.
    If you had two products in the 'Bob' category, then bob would only be returned
    once. Hope that helps, Daniel Short

    webshorts Guest

  3. #3

    Default Re: Eliminating Doubles in SQL

    Awesome, that worked
    Marsbar24u Guest

  4. #4

    Default Re: Eliminating Doubles in SQL

    .oO(Marsbar24u)
    >I am developing a ecommerce website. In dreamweaver I have the product
    >categories from the database display as links, my problem is that there is more
    >then 1 product with the same category name and so there are multiple same name
    >categories showing up as links. How do i remove multiples?
    Why not split it and use one table for the categories and another for
    the products?

    Micha
    Michael Fesser Guest

Similar Threads

  1. Freehand doubles prints
    By 54xmax in forum Macromedia Freehand
    Replies: 2
    Last Post: May 21st, 05:02 PM
  2. My XML import into inDesign doubles the carriage returns
    By Ben_Marchbanks@adobeforums.com in forum Adobe Indesign Windows
    Replies: 0
    Last Post: April 17th, 12:23 PM
  3. Problem with multiplying doubles
    By christine in forum PHP Development
    Replies: 4
    Last Post: November 29th, 01:59 PM
  4. Searching for doubles.
    By Eric Dekeuckelaere in forum FileMaker
    Replies: 1
    Last Post: October 27th, 12:55 PM
  5. win32api calling with doubles
    By ROTH Jakub in forum Ruby
    Replies: 1
    Last Post: August 11th, 10:14 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139