need help with a chat code problem
| From: | Deadsam | Date: | Thu, 29 Aug 2002 22:45:16 +0000 |
| Subject: | need help with a chat code problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-114567@lists.php.net to get a copy of this message | ||
Im building a chat with php/mySQL but I dont want my database to be filled
up with messages upon messages, what I want to do is make it start deleting
rows after lets say 100 rows (which hold the messages)(each individual row
holds one chat message), is there a way of doing this through deleting the
smallest numberID rows in that table? as each one I want to delete will be
the smallest ID number (as it grows with each message added to it).
If tried to figure this out but so far no luck.
If anyone can help me with this Id greatly appreciate it.
Thanks in advance
Deadsam