shoutbox help me here

[addie]

hi anyone can help me
i made basic post script like shoutbox
i need to know how i make mysql delete every 5 or 10 message it delete the older messages ?

[HalfaBee]

If you have an id for each comment you
could have a query something like this

"insert coment ....."

$last = mysql_insert_id( );
$last -= 5;
$sql = "DELETE FROM tablename WHERE table_ID < $last";
mysql_query( $sql );

HalfaBee