Limiting Number Of Records Stored In Database

[katl]

Is there a way I can limit the number of records that are stored in a database? I am using a PHP guestbook script for personal use and only want to save say the last 100 messages. Thanks!

[per1os]

Best way is to do a count before insertion.

 

IE:

<?php
$count = mysql_fetch_assoc(mysql_query("SELECT count(gbid) count FROM guest_book;"));
$count = $count['count'];

if ($count > 100) {
      mysql_query("DELETE FROM guest_book ORDER BY dateentered LIMIT 1;");
}
?>

 

Note unsure if it works correctly test it on a dev machine before using it in production.