help here

[addie]

hi peepz
all what i need is i have made shoutbox that user can send post but I need to know when 20 record reached to mysql.
I wanna make limit to 20 records and each new post delete old one. Anyone know how it works ?

[olaf]

Wich record has to be removed ?
I think this the question...

otherwise if a user posts:

check the number of records:
if the number of recs. is 20 then
create a query with a limit to get the record which has to be removed
delete this one

and finally insert the new one...

[addie]

umm let me explain
script looks like this

$last = mysql_insert_id( ); 
$last -= 20; 
$sql = "DELETE FROM tablename WHERE table_ID < $last"; 
mysql_query( $sql ); 

somethng like this
but this is not working

[seby]

that will remove all records and only leave 1 😉

try something like this:

$last = (mysql_insert_id() - 20);
$sql = "DELETE FROM tablename WHERE table_ID BETWEEN 0 AND $last";  

mysql_query( $sql );

[addie]

and what about removing oldest record ?

[seby]

what i posted will delete old records.. it will delete everything from ID 0 to the last insert minus 20 .. so you will always end up with the last 20 results.