Select Distinct Help
Posted: Wed Aug 05, 2009 11:41 am
Ok well I just started coding my own PHP/MySQL stuff a few days ago, so bear with me.
I have a table with fields name, time overallxp, overalllvl, overallrank, and so on.
It updates each day at the same time, inserting a new row for each name I give it, so each person has between 1 and 100+ rows of data.
I need to select only rows with distinct values in the `name` field, but I want all the information from those rows, currently I just get their names.
How do I select only rows with distinct `name` but return all the data in that row?
If you need clarification, just ask.
I have a table with fields name, time overallxp, overalllvl, overallrank, and so on.
It updates each day at the same time, inserting a new row for each name I give it, so each person has between 1 and 100+ rows of data.
I need to select only rows with distinct values in the `name` field, but I want all the information from those rows, currently I just get their names.
How do I select only rows with distinct `name` but return all the data in that row?
If you need clarification, just ask.