[DimensionX]

Hi,

I'm having a slight problem with displaying the newest 3 news submissions for a website:

SELECT * FROM [table] ORDER BY [date] DESC LIMIT 3

As it stands it kind of works to a point, using this it displays the newest 3 submissions but unfortunately when it comes across more than one submission that has the same date it displays them in the incorrect order.

for the moment the date is manually entered, i've double checked the dates i entered and they are exactly the same, theres no timestamp to compare, I assume that would have the same problem if it came across 2 submissions of the same date and time, admittedly the chances of that are extremely slim, but it just bugs me.

At the moment it's just displaying the entire entry using echo's with .$result_row['variable'], I would eventually like to get it so that it displays the body up to a certain number of characters and then has a hyperlink "read more" so the user can click on the link and read the entire news submission. If you could point me towards something that I should read up on in relation to that I would appreciate it also.

Thanks in advance for any help you can offer.

*just realized I can order by the primary key, or order by the date and primary key which should solve the problem.

[forgueam]

I definitely think you found the best (and simplest) solution. I almost always add an auto-incremented primary key to any table I create for situations just like this one.