Online Resrvation Database

[Robertvideo]

Greetings

Can someone look at http://24.29.137.85/bnlv/

I need to limit the number of reservations

per show and have the FORM kick back a message

sold out... I believe it's an FPM if statement

however I dont know the wording

IE: Seat limit is 150... so if someone books a show that is over the limit I want a page or message to pop up

Any suggestions

[softhead]

have 2 fields in your database, one called 'limit' and the other something like 'numRegistered'.

[FMP-If: numRegistered .lte. limit]

*This is where the regular code would appear*

[FMP-Else]

Sold Out!

[/FMP-If]

Hope this helps!

Anita

[softhead]

I guess I should explain a little more...hehe, sorry! the lte stands for less than or equal to gte would be greather than or equal to, if you don't want the 'equal to' part there, just drop the 'e' at the end. And also 'eq' means simply equal to That's for future reference if you need it!

Anita