Whats wrong in this SELECT FROM WHERE ORDER BY mysql syntax?

Returns a syntax error, but I dont understand where is the mistake... NOTE: dtadd is a TIMESTAMP

S开发者_开发问答ELECT codigo, quantidade, preco_unitario
FROM romaneios_detalhes 
WHERE id_romaneio = '.$idr.' 
SORT BY dtadd ASC

It should be ORDER BY not SORT BY.

Use ORDER BY instead of SORT BY

First, that should be ORDER BY

Secondly, the points around $idr .. are they just an artefact from copying them out of a PHP script?