seat reservation in cinemahall

Question

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?