no duplicates....

[Anon]

Hi there!

Simple problem:

I have mysql table where is rows like

manufacter | model | lenght | price | ...

airwalk | A-1 | 151 | 300 | ...

airwalk | A-1 | 153 | 310 | ...

airwalk | A-1 | 157 | 320 | ...

airwalk | B-1 | 152 | 327 | ...

airwalk | B-1 | 154 | 345 | ...

burton | charger| 147 | 340 | ...

burton | charger| 151 | 344 | ...

burton | balance| 146 | 270 | ...

burton | balance| 149 | 272 | ...

etc
etc

Now I want to have only the manufacter and model lines to my search result....NO DUPLICATES!

for example if I select all then result should look like

=irwalk A-1
Airwalk B-1
Burton Charger
Burton Balance
etc
etc

So only one row for each manufacter&model

Please help me..

/Arto

[Anon]

Use the DISTINCT keyword. SELECT DISTINCT column FROM blah...

[Anon]

normalizing your data would be a great help for this, there are articles here at php builder as well as on the net.
Jim

[ah66533]

Thanks for that...!!!