Hi there,

I am trying to set up a database to run an event planning website, and I need to limit the number of entries that are allowed per table, in relation to the number of guests allowed at each event.

Does anyone know how to specify a maximum number of entries per table?

....and further still: can someone tell me how to put a "sold out" message on my website when this max number is reached?

Thanks!

You'll need to write the limit into your application code rather that the SQL, but it's straightforward enough to do.  Here's an example of code (in PHP in this case, but the principle's the same whatever language you use) from our website that looks up the number of books in our library tables:

Code:

$cid = mysql_query("select count(isbn) from books"); $r = mysql_fetch_row($cid); $bookcount = $r[0];

and then all you need to do is provide two sets of alternative code ...

Code:

<?php if ($bookcount > 80) { ?>     .... put the HTML for "Our shelves are full" here ..... <?php  } else { ?>      .... put the form offering places for sale here ..... <?php } ?>

---