delete fixed number of records

[alirezaok]

i have a table with one field
this field saves times as records
i want to there are 40 recoreds always

in other mean when inserts 41'st record then 1'st record be delete
how to delete fixed number of records at a time of first of my records asc (like select)

in other mean i want to like:
delete from table order by time asc limit 0,1

[bough]

do you mean that after you have inserted 40 records, you want to remove the first record in the table each time a new record is entered, keeping the latets 40 entries?

ie $entries = "select count(field1) from table1"

to give you the number of entries

you would need to select the row that you want to delete

ie $value = "select field1 from table1 limit 1"

you can then just do a delete like

delete field1 from table1 where field1=$value limit 1

Is that of any help?

[alirezaok]

yes. thank you very much 🙂

[bough]

that should be

delete from table1 where field1=$value limit 1

rather than

delete field1 from table1 where field1=$value limit 1

to many field1's 🙂

hope it works