Database Chop

DigitalExpl0it

Any one have a clue on how to delete the most first recorde..dont know if that makes since..

ok I have a database with a table called chatterbox, in this table I have these feilds..

CID
CName
CMesg
CDate

now lets say I have 10 records in this table

test
test
test
test
test
test
test
test
test
test

now when I insert a record I want to delete the first record, in this case it would be record number 1.

so then it should look like this..

test
test
test
test
test
test
test
test
test
test

then I insert another record and it should delete record 2.

test
test
test
test
test
test
test
test
test
test

etc...

any ideas?

mahers

Only way I can think of is:

// Query the database first and get the id of the first record.
// I presume you want to get the oldest record first?
$id = mysql_query("SELECT CID FROM chatterbox ORDER BY CDate ASC LIMIT 0,1");

// Delete the id
mysql_query("DELETE FROM chatterbox WHERE CID=".$id."");

// Insert new record
mysql_query("INSERT INTO chatterbox.. etc");

DigitalExpl0it

hey thanx looks like it works 🙂