Windows [Gesior] Character.php - Row 193 - Death list

[frankfarmer]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'time' in 'order clause'' in E:\OTSERVER\xampp\htdocs\characters.php:193 Stack trace: #0 E:\OTSERVER\xampp\htdocs\characters.php(193): PDO->query('SELECT * FROM p...') #1 E:\OTSERVER\xampp\htdocs\index.php(153): include('E:\OTSERVER\xam...') #2 {main} thrown in E:\OTSERVER\xampp\htdocs\characters.php on line 193

This is line 193

$player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY time DESC');

If i delete that row, it works but i can't see player deaths.

Anyone can see the simpleness in this? I can't.

+Rep for the one that helps

 

[Metor]

Try:

$player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY date DESC');

 

[Mastara]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'time' in 'order clause'' in E:\OTSERVER\xampp\htdocs\characters.php:193 Stack trace: #0 E:\OTSERVER\xampp\htdocs\characters.php(193): PDO->query('SELECT * FROM p...') #1 E:\OTSERVER\xampp\htdocs\index.php(153): include('E:\OTSERVER\xam...') #2 {main} thrown in E:\OTSERVER\xampp\htdocs\characters.php on line 193

This is line 193

$player_deaths = $SQL->query('SELECT * FROM player_deaths WHERE '.$player->getId().' = player_id ORDER BY time DESC');

If i delete that row, it works but i can't see player deaths.

Anyone can see the simpleness in this? I can't.

+Rep for the one that helps

Your Problem is that you don't have a column called "time" in your databse. So you have maybe column "date". So use the query of Meteor. Or just change the line from time-->date if you got "date" in column.

 

[frankfarmer]

Thanks i'll try that when i get home. I'll rep you if it works!

Again, thanks alot.