I have a database which contains player logs.
The database is mysql and contains a day, month and year.
I'm looking for a query so that i could see who hasn't made any progress in 6 day's or more. (this means that the points has stayed the same)
Who can give me the correct query?
I now have a query that displays the "players" and shows the points.
Also, a date is created with the year, month and day
SELECT p.playername, (CONCAT_WS('/',ph.year, ph.month,ph.day)) as datum, ph.points
FROM players_history ph, players p, galaxytool c
WHERE ph.player_id = p.id
AND c.player_id = p.id
AND ph.points < 5000
ORDER BY p.playername ASC