PHP MYSQL stat limiting milestones?

User20cls921207

New member
I'm coding stats of a sports athlete. I want to show benchmarks in his career or milestones have you. Such as when he reached 100 goals or 400 games played. I basically want the single stat to be limited to that milestone record.

The real problem I'm having is wrapping my head around trying to limit stats to only show like ONLY 50 goals, 200 goals, 500 assists, 900 games played, etc... but also have the data supporting when he achieved that milestone. It seems like there needs to be a sum somewhere in this and somehow have the database ignore anything beyond that milestone number.

Let me know if you're lost in my rambling and I will try and best explain further in the additional notes.

Thanks in advance.
Well all the info are stored within each individual game. I'm just having trouble with limiting these stats to only display the milestones/benchmarks. It's pulling from only one database, the game database.

For example. Say I want to display the first 200 goals (300+ goals, it needs to not display any goals after 200), and then display data on the 200th game like when, where, score, etc.
 
Back
Top