Database

Question

I'm new to coding and trying to build an Android app, where you can track your cigarettes you smoked... So far I got a database where I can add values and display them again... Now I want to compare the last time I smoked with now... I'm stuck in getting the last entry of the database back! Maybe someone can help me out?

Answer 1

SELECT * FROM `smoked` ORDER BY `date` DESC LIMIT 1

I'm making a lot of assumptions here about your tables. If you don't have a date field order it descending by the primary key which should be auto incrementing.

Answer 2

Thank you Adam... You helped a lot....