Only showing one unique fields

[MitchEvans]

I have some fields that have the same id and want to display them all in a table or similar. At the moment it's just showing the id's but there are no repetitions of that id, as in the database these id's have different data.

So if i had the data like below:

//id// //data//
c1 34
c1 25

I need the data to display exactly what is shown above and not just one of the c1 id's.

[bogu]

SELECT id, data FROM table