<?php
require_once('sqlconnect.php');
$query = 'SELECT id FROM xxxx ORDER BY date_timestamp DESC LIMIT 0,70';
$query_result = mysql_query($query);
//Récupération des id des 70 derniers enregistrements
while($row = mysql_fetch_array($query_result)):
$id_array[] = $row['id'];
endwhile;
//Suppression pour chaque id récupéré auparavant
foreach($id_array as $key=>$value):
mysql_query('DELETE FROM xxxx WHERE id = '.$value.' LIMIT 1');
endforeach;
?>
darkelda
Développeur PHP&MySQL / Webmaster Freelance
Suivez Moi