getting the last value

[jannoy]

how would i get the last value of tables?

eg.
field name | value
name | jose
name | jose2

then i will display
jose2 only

[Shrike]

This should be in the Database Help forum

"SELECT name FROM table LIMIT -1"

This doesn't necessarily mean the most recent row in the table.

[jannoy]

wont work using limit

[jannoy]

thanks it works now