Getting last row even with Limit

[Andy Edwards]

Hello I had a query and wanted to know about how to resolve this.

I am using PHP and MySQL to get data from a table. My code is

"

$queryA = 'SELECT estimate_attachment.*, estimate.* FROM ';

$queryA.= '(estimate LEFT JOIN estimate_attachment ON estimate.estimate_id = estimate_attachment.att_estid) ';

$queryA.= 'WHERE estimate_id="'.$_GET["estid"].'" ORDER BY att_created DESC LIMIT 1';

"

Most of the records have the same date and multiple rows exist for that estid. However, it brings back a row which is still not the last row. When I browsed to the data there are 23 rows so it should bring back record 23 but instead it brings back row 14. Do you know why it does that? Thanks for your help.