PDA

View Full Version : Auto Update


iegn
11-10-2007, 04:26 PM
Iím working on online cinema booking system. User allow to view hall seating plan before proceed to book ticket. Each seat has 3 status- available, reserved and sold represent by 3 different colors. Staff will change the seat status from reserved to sold after customer go to counter to pay for the ticket they had booked online. My question is how to auto update the seat status in database from available to reserve after customer book movie ticket online. Iím using ASP and Ms Access.
Any help would be appreciated

tux
11-10-2007, 07:03 PM
There are very few ASP people on this forum it is mostly PHP.

Cant help with the ASP code but you need to add a field to your DB table that holds the seats and call it maybe Status. Then populate it with a value for each status, ie. 1 for available, 2 for reserved and 3 for sold. Then you can reference this in your code. Each seat in your table will then have a status.

Hope this helps and sorry I cant help with the ASP. I'm sure others will come forward with more advise.

If you want to use PHP then Davidj's videos are a great place to start. Check them out here......

http://www.dreamweaverclub.com/vtm/php-mysql-apache.php

Regards Paul.