Get a list of names from a database with multiple entries using php

Question

OK, Basically I am after some advice as I am not sure how to do this, basically I have a database full of car details, what I want to do is auto populate a page with a list of the manufacturers. I am thinking I could do this with group, although I do not particularly need to group the results just show the name of every manufacturer just once as a link.

Is group the best way to go?, or is there another way?.

Any advice would be appreciated.

Thanks

Landon · Accepted Answer · 2012-11-03 21:29:18Z

1

you can do a group by as you mentioned, or you can do distinct:

select distinct manufacturer from cars where 1

Read more about it here:

http://dev.mysql.com/doc/refman/5.0/en/distinct-optimization.html

answered Nov 3, 2012 at 21:29

Landon

4,1183 gold badges33 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stan Williams Over a year ago

Thanks, never though of distinct, much appreciated

Collectives™ on Stack Overflow

Get a list of names from a database with multiple entries using php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related