Hey i got problem with this script. if the player makes 2 and more report i can show on my website only first report. In my database i can show all. If i deleted one report from the same player in database - on website the other is jumping like this:
![35994 35994](https://static3.otland.net/d/attachments/27/27485-136650af2153d8c946fd23ad16c95419.jpg)
![35995 35995](https://static3.otland.net/d/attachments/27/27486-092c2562425fcead8ddca4aac2aa936d.jpg)
Edit:
change to:
![35994 35994](https://static3.otland.net/d/attachments/27/27485-136650af2153d8c946fd23ad16c95419.jpg)
![35995 35995](https://static3.otland.net/d/attachments/27/27486-092c2562425fcead8ddca4aac2aa936d.jpg)
Edit:
PHP:
foreach($SQL->query('SELECT id, name, posx, posy, posz, report_description, date FROM player_reports GROUP BY name ORDER BY id DESC limit 20;') as $report)
change to:
PHP:
foreach($SQL->query('SELECT id, name, posx, posy, posz, report_description, date FROM player_reports GROUP BY id ORDER BY id DESC limit 20;') as $report)
Last edited: