mramkumar 0 Newbie Poster

Hi,
my front end is jsp and my backend is mysql
iam design online cinema ticket reservation . It contains no of seats. if i choose 3 or 4 seats in checkbox,it stored in my database. After i refreshing the page that checkbox seats should be bolocked..
im saving film date,time,movie name,no of tickes,seat values, eveyting in same table... if another user clicks the same movie,time,date already booked seats should be blocked.....pls any one help me out.. my review date is nearing pls...