[Resolved] Returning Certain Values Only

[webmasternovis]

Hi all.

I'm retrieving data from a database, and displaying it on a page. Simple enough.

However, a lot of the fields on seperate rows are the same. So if one row has a field called "John", a lot of the others may as well. What I want to do is just output this once. So instead of outputting "John" the number of times I'm outputting the rows, I just want it to be printed once.

Make sense?🙂 Best I could explain it really 🙂

Could anyone help?

Thanks,
Mike

[TheDefender]

Add a GROUP BY to your query:

SELECT * FROM table GROUP BY name

[webmasternovis]

Heh, thanks for the very quick response TheDefender 🙂

It all works now, thanks very much 🙂

[TheDefender]

You're welcome. Have a good one.😉