On Sunday 28 July 2002 17:37, JJ Harrison wrote:
> I know how to delete stuff from a db.
DELETE FROM table WHERE something_or_another
> Now I want to delete all the earliest entires from the database except the
> latest 75 entries.
How do you define 'earliest' and 'latest'? Do you have a date/time associated
with each record? If so use it the WHERE clause above.
> Is it easy or hard?
Depends on how long the piece of string is :)
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Old age is the most unexpected of things that can happen to a man.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php