



how to get the current location for student. base on id.
as u can see from my table which is Arnold current location is no 3 and krish is no 4.
let say i delete the Arnold then krish will replace the current location of Arnold is no 3.
kindly please advise.



sorry for ma bad eng.