legolas23
New Member
- Joined
- Jan 8, 2009
- Messages
- 537
- Reaction score
- 3
Mógłby ktoś poprawić?
Skrypt ma wyświetlać 5 osób z największym storage value 16969.
Błąd :
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = 16969 player_storage.player_id ORDER BY value DESC LIMIT 5' at line 1' in /var/www/layouts/kungsv3/layout.php:252 Stack trace: #0 /var/www/layouts/kungsv3/layout.php(252): PDO->query('SELECT * FROM p...') #1 /var/www/index.php(313): include('/var/www/layout...') #2 {main} thrown in /var/www/layouts/kungsv3/layout.ph
Skrypt ma wyświetlać 5 osób z największym storage value 16969.
Code:
<?PHP
$players_deaths_data = $SQL->query('SELECT * FROM player_storage WHERE key = 16969 player_storage.player_id ORDER BY value DESC LIMIT 5;');
foreach($players_storage_data as $dead) {
$vowels = array("e", "y", "u", "i", "o", "a");
$players_row5 .= '<b><td align="left"><br><br><font size= "1" color="silver"><b><a href="?subtopic=characters&name='.$dead['name'].'"><B>'.$dead['name'].'</B></a> <b>'.$dead['level'].'</b> level by <br> ';
if(is_numeric($dead['killed_by']))
{
$player_char = new OTS_Player();
$player_char->load($dead['killed_by']);
if($player_char->isLoaded())
$players_row5 .= '<font size= "1" color="silver"><a href="?subtopic=characters&name='.$player_char->getName().'"><b>'.$player_char->getName().'</b></a><br></font>';
else
$players_row5 .= '<font size= "1" color="silver"><b>DELETED PLAYER</b></font>';
}
else
if($dead['killed_by'] == "-1")
{
$players_row5 .= "item or field";
}
else
{
if(in_array(substr(strtolower($dead['killed_by']), 0, 1), $vowels))
{
$players_row5 .= "an ";
}
else
{
$players_row5 .= "a ";
}
$players_row5 .= $dead['killed_by'];
}
}
$players_row5 .= '</font></TD></font></font></b></align></TR><br>';
echo ''.$players_row5.''
?>
Błąd :
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key = 16969 player_storage.player_id ORDER BY value DESC LIMIT 5' at line 1' in /var/www/layouts/kungsv3/layout.php:252 Stack trace: #0 /var/www/layouts/kungsv3/layout.php(252): PDO->query('SELECT * FROM p...') #1 /var/www/index.php(313): include('/var/www/layout...') #2 {main} thrown in /var/www/layouts/kungsv3/layout.ph