Code: Select all
$sql = mysql_query("SELECT * FROM table_name ORDER BY ID DESC LIMIT 5");
Moderator: General Moderators
Code: Select all
$sql = mysql_query("SELECT * FROM table_name ORDER BY ID DESC LIMIT 5");
Code: Select all
$sql = mysql_query("SELECT * FROM table_name order by id desc limit 1");
while($row = mysql_fetch_assoc($sql)) {
$id = $row['ID'];
}
$newnum = (int)($id - 5);
$sql2 = mysql_query("SELECT * FROM table_name");
$num = mysql_num_rows($sql2);
if($num > 5) {
$sql2 = mysql_query("DELETE * FROM table_name WHERE ID < '$newnum'");
Code: Select all
$check = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' DESC LIMIT 10");
while($rowr = mysql_fetch_object($check))
{
$check2 = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' AND id != '$rowr->id'");
while($rowr2 = mysql_fetch_object($check2))
{
mysql_query ("DELETE FROM recent WHERE ipaddress = '$ip' AND id == '$rowr2->id'");
}
mysql_free_result($check2);
}
mysql_free_result($check);
Code: Select all
$check = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' DESC LIMIT 10");
while ($rowr = mysql_fetch_object($check))
{
if ($id1 == NULL) { $id1 = $rowr->id;}
if ($id1 != NULL && $id2 == NULL) { $id2 = $rowr->id;}
if ($id1 != NULL && $id2 != NULL && $id3 == NULL) { $id3 = $rowr->id;}
if ($id1 != NULL && $id2 != NULL && $id3 != NULL && $id4 == NULL) { $id4 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 == NULL) { $id5 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 != NULL && $id6 == NULL) { $id6 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 != NULL && $id6 != NULL && $id7 == NULL) { $id7 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 != NULL && $id6 != NULL && $id7 != NULL && $id8 == NULL) { $id8 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 != NULL && $id6 != NULL && $id7 != NULL && $id8 != NULL && $id9 == NULL) { $id9 = $rowr->id;}
if ($id1 !=NULL && $id2 != NULL && $id3 != NULL && $id4 != NULL && $id5 != NULL && $id6 != NULL && $id7 != NULL && $id8 != NULL && $id9 != NULL && $id10 == NULL) { $id10 = $rowr->id;}
}
mysql_free_result($check);
if ($id10 != NULL)
{
mysql_query ("DELETE FROM recent WHERE ipaddress = '$ip' AND (id != '$id1' AND id != '$id2' AND id != '$id3' AND id != '$id4' AND id != '$id5' AND id != '$id6' AND id != '$id7' AND id != '$id8' AND id != '$id9' AND id != '$id10')");
}Code: Select all
while ($rowr = mysql_fetch_object($check))Code: Select all
mysql_free_result($check);Code: Select all
$check2 = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' ORDER BY ID DESC LIMIT 10");
while ($rowr = mysql_fetch_object($check2))
{
$check3 = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' AND id < '$rowr->id'");
while ($rowr2 = mysql_fetch_object($check3))
{
echo "$rowr2->id<br/>";
} mysql_free_result($check3);
} mysql_free_result($check2);Code: Select all
$check2 = mysql_query ("SELECT * FROM recent WHERE ipaddress = '$ip' ORDER BY ID DESC LIMIT 10, 1");
while ($rowr = mysql_fetch_object($check2))
{
mysql_query ("delete from recent where ipaddress = '$ip' AND id = '$rowr->id'");
} mysql_free_result($check2);Code: Select all
DELETE
FROM
`recent`
WHERE
`ipaddress` = '$ip' AND
`id` NOT IN ('id1','id2','id3','id4')