[Yusayoh]

Hey,
I'm trying to select a row from a database. I have the database in an order by points thing and I want to select a row from it (like third from the top of that form, not regular) and extract information from it such as name etc.

Hopefully this can help you understand better (already in order by form):
|MOST POINTS|
|Second most points|
|Third most points|

I want to get information from the third most points like name, age etc. How can I accomplish this?

Thank you!

[End User]

Something like this ought to do it:

Code:

$query = "SELECT type, MAX(points) FROM sometable GROUP BY points LIMIT 3";

[Yusayoh]

Originally Posted by End User

Something like this ought to do it:

Code:

$query = "SELECT type, MAX(points) FROM sometable GROUP BY points LIMIT 3";

What is type? A column I want to information from (like name)?

[UnrealEd]

Originally Posted by Yusayoh

What is type? A column I want to information from (like name)?

Yes, after the SELECT statement you place or a wildcard, being *, or you specify which column you want to get info out of the database. You can also execute functions on the column, while getting the data (this is what is done with the MAX() function)

UnrealEd

[Christian]

Moved to Databases.