php/MySQL Repeated region which doen't include the last item?

Forum|Forum|15 years ago
October 4, 2010
1 reply
518 views

Hi,

I hope somebody can help me with this. I use php/MySQL.
I need t create a repeated region which doen't include the last item (post) added to the table.

Does somebody know how to establish this?

Server side applications

This topic has been closed for replies.

B

bregent

Participating Frequently

In SQL, there is no native concept of the last item inserted. It's up to you to control that. What is your definition of the last item? Is it the row with the greatest datetime stamp? An autoincrement id field? Something else?

Using an autoincrement id field as an example, the last row inserted will have the largest value, so

Select * from MyTable where MyID != (select max MyID from MyTable)