Database containing 6 records....

[Anon]

I'm making a tag board, that displays the first 6 records in the database. Does any body know how I can use php to determine when there are over 6 records, and to delete the ones over 6... appreciate your help.

[Anon]

Use an autonumber ID field, and sort it descending with your SQL. The get the 6th record and then delete all records less than it.

$sql = "SELECT id FROM tbl_blah ORDER BY id DESC";
$results=mysql_query($sql);
$value_6 = mysql_result($results, 6);

Then...

$sql = "DELETE FROM tbl_blah WHERE id>'$value_6'";
$results=mysql_query($sql);

AaronZoller.com

P.S. You better check on the syntax of mysql_result to make sure I got that right. Been a while since I've used it. Also, I would recommend you use a SELECT to test your query before you run the DELETE FROM. Or copy the table and test it on the copy.