How to limit how many people can choose something in mysql database using php

[Delqath]

I am building a website for a company that has clients sign up for activities on their website.  Everything works using mysql and php, but right now I have to monitor how many people are signed up for each event, and take an event off the page if it is full (ex: only 50 people can sign up for the spa package).  Is there a way for me to either code php to put a limit on how many people can choose an activity, or limit it in the database its self?

 

Thanks in advance

[The Little Guy]

My best guess would be like this, but it is hard to say without code

 

if(mysql_num_rows($sql) < 50){
    // Open still
}else{
    // Closed
}

[allworknoplay]

This is easy.

 

Everytime the page loads, it does a count on your tables for each of your categories.

 

If less than 50, then you display the category.

 

If not, then you display it.

[Delqath]

hmm ok sounds like I need to break up my table... I am only using one table right now becuase there are only 3 choices people have to make, but it sounds like breaking it up is the way to go.

[printf]

Add two columns to the event table (signed_up = total that have signed up,total_allowed = total number allowed to sign_up [50]) that counts how many have signed up.

 

// query to display opened events, won't show events that are full

 

SELECT * FROM events WHERE signed_up < total_allowed ORDER BY event_date;

 

// when someone signs up

 

UPDATE events SET signed_up = signed_up + 1 WHERE event_id = some_id;

[allworknoplay]

hmm ok sounds like I need to break up my table... I am only using one table right now becuase there are only 3 choices people have to make, but it sounds like breaking it up is the way to go.

 

 

Big or small, always design the your DB with scalability in mind....

[The Little Guy]

if you use a select to get all the people who have a "spa package", then you really don't need to break your table up.