ibanez270dx Posted August 25, 2006 Share Posted August 25, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/18662-selecting-specific-data/ Share on other sites More sharing options...
ober Posted August 25, 2006 Share Posted August 25, 2006 SELECT DISTINCT make FROM products WHERE blah blah. Quote Link to comment https://forums.phpfreaks.com/topic/18662-selecting-specific-data/#findComment-80438 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.