restrict number of entries into database - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

sclarkstone · 02-17-2009, 02:52 PM

Hi. I have a form which dumps the responses into a table in my database. i want to be able to restrict the number os responses and one that number is reach hide the form, any ideas? thank you in advance.

Ariyes1 · 02-18-2009, 07:47 AM

Well, I can't write the code for something like this, but I do have an idea.
A PHP script should count the rows in the response table. If it's more than, let's say, 30 rows(responses), then another PHP script shal echo out nothing/or text instead of the form.

Like:

Code:

if ($rowcount == "30") {
  echo "We do not need more responses, thank you";
}

sclarkstone · 02-18-2009, 09:40 AM

Thats great, got that working. say i have a drop down menu in the form and i have a limit on how many reponses i want for each option in the drop down menu. So one option may fill up before the rest but the form needs to be visiable until all of the numbers have been met on all of the options on the drop down. It would be great if i could make the option not appear on the drop down list if the number has been met. does anyone have any ideas how i can do that? thank you in advance.