var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select statement to get the all data with last sr_number save
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
it display all data from my database.
SELECT last_insert_id(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
SELECT max(sr_number), sr_date, Items, SubItems, ItemCode, DemandedQty FROM stock_requisition;
for example :
I attach my sample data from my database:
Thank you so much
LAST_INSERT_ID() returns the value of the last auto_increment immediately after an INSERT
you do not have an INSERT