ultra newb help

[mwjansen]

i do motorcycle tours with a maximum # of riders per tour. right now my site is static html - so whenever someone books a tour, i go in manually (ugh) and update the number of slots available.

 

i'm in the process of switching to php/mysql - i've read a beginners book and studied many online resources. so far, i my db set up and a very basic knowledge of php. i can access the tables and get data populated via php no problem.

 

naturally, what would be ideal is when someone books a tour, that payment info gets into my table, and then decreases the available slots by one, which is then displayed on the site.

my table currently has fields of 'total' and 'booked' - my thinking was to increased 'booked' by one, and then calculate the open slots as 'total' less 'booked', but i don't know how to do that either ;(

 

for the life of me i can't figure out (or find out) how to accomplish this. if there's a tutorial out there, or script available, or someone willing to help - be much appreciated. if its alot of work, be willing to pay for a script written as well.