Generating links

[Anon]

I'm using the while loop to generate links example
once you enter a product it will add a link to a list. the list is by catagory but if you have the same name ie speakers the list looks like.

Speakers
Speakers
Cabanits

I don't want it to have the double link I want it to be one link if speaker exsit it should not double the link it should leave one link and add the second speaker as list of the first speaker link.

Using MySQL as a DB

Hope you understand
TIA
Rich

[Anon]

Look at the GROUP BY sql clause. Whatever field holds the Speakers or Cabinets value, just add to the end of your SQL query:

GROUP BY <field>

that should do it.

Hope that helps.

Chris King

[Anon]

or SELECT DISTINCT column_name FROM table_name

---John Holmes...