Getting the latest row inserted to the sql for a certain ID

Question

I am creating a Current Salary Report

This is my query:

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id";

And the output is: output and by scrolling down, this is the continuation of the output.

To sum it up, the query displays all the records of a certain ID but I would want it to display the last inserted data of this certain ID in the database. How can this happen?

Answer 1

To get the latest row you must order by id desc and to get only one record set limit 1.

So the code will be

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC LIMIT 1 ";

Answer 2

try this

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC  LIMIT 1 " 

if the newest ID is the largest value.

Answer 3

Use this MySQL ORDER BY or LIMIT

$sql = "SELECT *
FROM payroll, employees
WHERE employees.username='$username'
AND payroll.id=employees.id ORDER BY employees.id DESC LIMIT 1";

Answer 4

$sql = "SELECT t1.*,t1.*
FROM payroll t1 join employees t2 on t1.id = t2.id
WHERE t1.username='$username' order by t2.id desc limit 1";