removing last record ?

addie

hi people iv been posting this messaga long time but I did not get right answer what i need it i have table name to mysql, named (test) and example i have total 5 records when anyone submit 6 i wanna script automaticly remove old one and add new record
there is my code what i use but that script is missing:

<?
$table = "test";

require_once 'config.php';
MySQL_connect("$host","$login","$pass");
MySQL_select_db("$db") or die("Could not select database");

if (isset($_POST['submit'])) {
  if (!$_POST['username'] | !$_POST['message']) {
	die('You did not fill in a required field.');
}

$username = $_POST['username'];
$message = $_POST['message'];
}

$sql = "INSERT INTO $table SET username='$username',message='$message'";
$result = mysql_query($sql);
if ($result) {
echo "blla";
}
?>

The_Chancer

OK - if I get this right...

User submits data 5 times, then on the sixth go, the oldest one (ie the first) submitted form will be deleted - leaving only 5 rows ?

If so, use the timestamp as a column, and delete the row that is the oldest.....

addie

how to use timestamp ?

tbach2

Before you go any further, you need to read up on database design. What you currently have won't allow what you want to do, because you don't have a primary key. Therefore you have no way of identifying any particular row.

Depending on how you plan your database, there could be several ways to do this-- (I'm assuming you want a simplistic chat board)

Use a time stamp and 'LIMIT 10' to display only the latest 10 records, then delete all messages older than x hours or days old
use the autoincremented id field-- count number of rows, if >=10 then select the row with lowest id number, grab that id and then delete that row. Then insert your new row.
[/list=1]

tbach2

BTW you're also mixing up INSERT and UPDATE syntax. Better check the manual to get that straightened up 😉