Jj Harrison wrote:

> I know how to delete stuff from a db.

> Now I want to delete all the earliest entires from the database except the
> latest 75 entries.

> Is it easy or hard?

I would say easy..

> I know about limit but it doesn't seem to work the other way.

Assuming you have nothing to associate your records with time of entry, 
I agree LIMIT seems to be the easiest.

If you have sub query try something like this.
DELETE from file limit (SELECT count(*) - 75, ',', count(*) from file)

If no sub query you probably have to do it with 2 queries. One to get 
the  number of records and the other to substitute the variable 
$num_records into the DELETE as
DELETE from file file limit $num_records - 75, $num_records


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

Reply via email to