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