HOW? Display a form until a set number of submissions is reached

I am not sure if this is possible, but is there any way to build a submission form (to enter a competition for example) that displays UNTIL 100 entries have been received? Once 100 entries have been received the form no longer appears/another page is shown etc. to stop further entries.

Strange request, but I am really struggling to find a way to do this.

Any help greatly appreciated.

Regards,

Lee

each time the form is supmited, you would need to use an insert recrd behavior to store the form contents to a database table.

you could then create a recordset that will return all records from the table:

SELECT * FROM tableName

the number of rows returned by the recordset will be stored in a variable created named:
$totalRows_<recordsetName>


where <recordsetName> is the name of the recordset.


you could use an if statement around the form:

<?php if($totalRows_<recordsetName> < 100) { ?>

<form...

form code

</form>

<?php } ?>

Thanks for that. Next question!
Is it possible to do this on a daily basis?

ie. allow 100 entries per day, then display a 'Please try again tomorrow' message?

create a new column in the database and name it submitDate.

add a hidden element to the form and set the value of it to:

<?php echo(date("Y-m-d")); ?>

in the insert behavior, bind the submitDate column to the hidden form element.

then change the recordset to

SELECT * FROM tableName WHERE submitDate = curdate();