seat reservation in cinemahall
Hello,
I would like to make a seat reservation program with a
access database.
I have 150 seats I use 150 buttons for this.
In my database ik have a columm seatnumber from 1 to 150
and I have a columm booked with "0" and "1" values: 0 =
free 1 = booked.
In my page_load i want to make a query that looks which
seats are booked en which seats are free.
The free seats buttons are green and the booked are red.
so thats my problem I cant find the qeury that the
buttons change the colors.
Can someone help me?