Jump to content


Photo

Selecting Specific Data


  • Please log in to reply
1 reply to this topic

#1 ibanez270dx

ibanez270dx
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts

Posted 25 August 2006 - 06:48 PM

Hi,
I have a product catalogue DB that includes fields for make, model, etc... There will be a lot of repetitiveness in the make field, for example, the make could be Ford and the model could be Ranger or F150 or whatever.

The thing is that there WILL be multiple makes, just there will be many repetitions. What I need to do is to pull out each make, but only once so I can have a bulleted list of the makes w/o repetition. How can I do this?

Thanks,
- Jeff

#2 ober

ober
  • Staff Alumni
  • Advanced Member
  • 5,337 posts
  • LocationEast Coast, USA

Posted 25 August 2006 - 06:53 PM

SELECT DISTINCT make FROM products WHERE blah blah.

Info: PHP Manual





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users