Limiting amount of adding to database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
James138
Forum Newbie
Posts: 18
Joined: Thu Feb 05, 2004 1:41 pm

Limiting amount of adding to database

Post by James138 »

Hi,
I'm trying to get my database so that you can only update the table a number of times. I have got a table with MemberID, CompetitionID, CompetitionTimes. I need to be able to add no more than 4 membersID per time on. At the moment Im inserting a memberID with a competition time, and i can do this x amount of times. But i want to limit this to a maximum of times per competitiontime. Is there a way of soing this??

Cheers
James138
Forum Newbie
Posts: 18
Joined: Thu Feb 05, 2004 1:41 pm

Post by James138 »

What basically i need is that I can assign memberID with a competition time update to database. Where the competition time cannot appear more than 4 times in the database. Is there anyway i can do this?

thanks
Post Reply