First I tried to look for the answer on here(stackoverflow) as well as other sites like a microsoft forum, but couldn't find anything that answered my question. Or I just couldn't understand.
I'm working on a (school)project I got from a company, they gave me acces to their database. In here is a table with data from a sensor that registers stuff every once in a while.
Now my question is: I want to get the last data inserted into the table and show just one row (echo or print, I dont really mind how, I just want it to work and to understand it.)
The table looks as followed: Tablename= container_1
I want to show the last inserted data in COL 3. Is there a way to do this with the table the company provided me with?
Using phpmyadmin you can:
Select * from your_table order by col1 desc Limit 1;
This way you'll only have the last entry