I have a giant table called images. I am trying to grab the last six updated rows in this table. For some reason MySQL seems to be dropping the last 5 rows....here is my statement:
"SELECT * FROM images ORDER BY date LIMIT 6"
date is a timestamp of when the image was uploaded (and the row created)....so I should be getting the last 6 rows with this query....but it seems to missed the last 5 rows......
Anyone had a similar problem?....help needed
"SELECT * FROM images ORDER BY date LIMIT 6"
date is a timestamp of when the image was uploaded (and the row created)....so I should be getting the last 6 rows with this query....but it seems to missed the last 5 rows......
Anyone had a similar problem?....help needed