Problems with a query

[onlinegamenet]

Usually things work when I add a new section in, but I am having a problem with this

anyway.

$get = mysql_query(" 
SELECT at.*, ft.*, pt.*, us.username AS POSTER
FROM attachments at, posts pt, topics ft, users us 
WHERE pt.post_attachment = 1 AND  ft.topic_first_post_id = pt.post_id AND ft.topic_poster = us.user_id
ORDER BY ft.topic_time DESC LIMIT 5") or die (header("Location: http://www.onlinegamenet.com/error/database.php"));

that is the query I am using to get a post, some info about it, a username and the attached file, however, It echo's the same attachment the length of the limit, although if I increase it to 15, it stops echoing the newer attachment after 13 times.

http://www.onlinegamenet.com/1/s/download.php - where it isn't working.

Other pages I've done, don't include the attachments table, but they work fine.

[jg_v7n]

The "LIMIT" needs two components, a start number and the length, so for example "LIMIT 0, 5" starts at row 0 and selects 5 rows. "LIMIT 5,10" starts at row 5 and selects 10 rows.