Limit number of entries in a MySQL DB

From: Date: Wed, 20 Sep 2000 04:22:58 +0000
Subject: Limit number of entries in a MySQL DB
Groups: php.general 
Request: Send a blank email to php-general+get-17271@lists.php.net to get a copy of this message
I am trying to limit entries into a MySQL database to avoid duplicate entries. Users will input values for a $week and $team. Teams can have multiple weeks, but there can not be multiple weeks per team. How can I check the MySQL DB prior to inputting values and if there is already values matching the $week and $team criteria exit and redirect to an update page? Hope this makes sense. I believe this should be fairly simple, but am not sure where to start. Any help would be appreciated. Thanks, Scott

« previous php.general (#17271) next »