thx.
"Dan Koken" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> 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
>
>
> HTH Dan
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
