I constructed a query in phpmyadmin which was successful. I then moved it into a php script, and am getting the error:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource (line 135)
$query="SELECT timestamp as timestamp FROM `stats` WHERE `pilot_callsign` = $player_id and `action` = 'kill' and `pilot_team` != `victim_team` order by 'timestamp' LIMIT 0 , 1;";
line 135: $row=mysql_fetch_assoc($result);
Can anybody explain what is wrong here?