sort data by monthly

[Smackie]

Alright I am in need of help.. i have a table in databased called reports.. its for games that we do. and I want to pull only the current month reports out and show everyones points for the month (showing the points from highest to lowest) can someone help me. Thank you

Smackie

[Kudose]

Post your schema

[Smackie]

what you mean by schema are you talking about query? i just said im not sure on how to make the query like i need it..

[Kudose]

Your schema is the way your database is laid out.

What are your table names? What are your column names? How is the data stored?

[Xager]

$query = mysql_query("SELECT * FROM _table_ ORDER BY _field_ ASC");

Change all values with _ after and before to what suits you, if it returns it in the wrong order use DESC instead of ASC

[bradgrafelman]

As Kudose points out, we need to see the schema (or structure) of the applicable table(s) in your database to help.

In general, if you had a date column called report_date, a points column called points, and a column containing the user's name, user_name, you would do:

SELECT user_name, points
FROM reports
WHERE MONTH(report_date) = MONTH( CURDATE() )
ORDER BY points DESC

I would recommend that you never using a "SELECT *" query and instead only SELECT the columns that you actually need data from.