my application is to reserve a resource for particular period of time
(min 1hr) so i store time into database as numerice value
i need to edit the reserved time
my problem is
(for eg)
a user reserve as 6.00 to 9.00
the same user reserve as 15.00 to 18.00 on the same day
if the user need to edit the time as 8.00 to 16.00 then i need to check the database and update it to 8.00 to 16.00 and those two reservation should not be present in the database
i dont know how to solve this problem
kindly help me in this regard
thank u in advance