select statement to get the all data with last sr_number save

[newphpcoder]

Hi..

I just want to know what is the code to get the last inserted row on database.

I tried max and last_insert_id yet it did not solve my problem

SELECT last_insert_id(sr_number), sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition;

it display all data from my database.

SELECT max(sr_number), sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition;

it only display last row.. but I need to display all data with all data with same sr_number
for example :

1204100002

I attach my sample data from my database:

Thank you so much

[ShaneC]

Can you show a screenshot with the column names? When getting LAST_INSERT_ID() you're getting the ID of a single record, yet you seem to be wanting multiple records.

[newphpcoder]

Originally Posted by ShaneC

Can you show a screenshot with the column names? When getting LAST_INSERT_ID() you're getting the ID of a single record, yet you seem to be wanting multiple records.

I attach the column names.

I just want to get all data with sr_number that was last save

Thank you

[newphpcoder]

It resolved my problem:

SELECT sr_number, sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition WHERE  sr_number = (SELECT max(sr_number) from stock_requisition)

Thank you

[Old Pedant]

That works, but it's more complicated than is needed.

Try simply

SELECT sr_number, sr_date, Items, SubItems, ItemCode, DemandedQty 
FROM stock_requisition
ORDER BY sr_number DESC
LIMIT 1

[guelphdad]

it also doesn't help that you waste people's time by posting your questions in multiple forums at once, you have people in this forum (and others) working on a solution for you while someone elsewhere already has given you a solution.