i am doing a library project for my college. in that, i have table called 'tbl_reserve' for store reservations. Structure is
Table Structure There are two date fields to store reservation date and expiry date. 'reserve_status' shows is it 'Reserved/Expired'.
is there is any way to automatic change the value of 'reserve_status' field after expiry date.
i am using PHP and MySQL.