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.
                -- Trotsky

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to