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

Delete the previous records and insert a new one. You would have the user id or something to look up for the records.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.