Last entry in a table

[bengt]

When i f.eks runs this query:

"SELECT * FROM table WHERE value = '50'"

and the query returns 5 entries.
How can I get the values for only the last entry?

[LarsLai]

well, your result is ordered in some way... don`t you want to order it by yourself? then you can do
ORDER BY yourfield DESC (or ASC) and get the first entry

[bengt]

DUH

/Me so stupid!!!

😉

Thanx