DELETE FROM

<?
if ($num > $config['markt']['charlie'])
{
	$loop = $num - $config['markt']['charlie'];
	for ($i=1; $i <= $loop; $i++)
	{
		mysql_query("DELETE FROM `DD_players` WHERE userid='0' && type='3' LIMIT 0,1")or die(mysql_error());
	}
}
?>

<?
if ($num > $config['markt']['charlie'])
{
	$loop = $num - $config['markt']['charlie'];
	for ($i=1; $i <= $loop; $i++)
	{
		mysql_query("DELETE FROM `DD_players` WHERE userid='0' && type='3' LIMIT 0,1")or die(mysql_error());
	}
}
?>

<?php
$query="SELECT * FROM DD_players";

$result=mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result) > 20)
{

$delete="DELETE FROM `DD_players` WHERE id");
mysql_query($delete) or die(mysql_error());

}
?>

<?php
$query="SELECT * FROM DD_players";
 
$result=mysql_query($query) or die(mysql_error());
 
if(mysql_num_rows($result) > 20)
{
 
$delete="DELETE FROM `DD_players` WHERE id");
mysql_query($delete) or die(mysql_error());
 
}
?>

<?php
$delete="DELETE FROM `DD_players` WHERE id='".$idrand."'");
mysql_query($delete) or die(mysql_error()); ?>

<?php
$delete="DELETE FROM `DD_players` WHERE id='".$idrand."'");
mysql_query($delete) or die(mysql_error()); ?>

<?php
//met hulp van een script hier op deze site
function random($a)
    {
    $cijfers = '0123'; //beperkt houden anders neemt ie cijfers zoals 87 enz. 
    $shuffle = str_shuffle($tekens);
    $pass = substr($shuffle,0,$a);
    return $pass;
    }
$idrand = random(2); //hoeveel cijfers je hier wilt. Als je wilt dat ie alleen ids kiest van 1 t/m 9 moet je maar 1 tikken anders 2
$query="SELECT * FROM DD_players";

$result=mysql_query($query) or die(mysql_error());

if(mysql_num_rows($result) > 20)
{

$delete="DELETE FROM `DD_players` WHERE id='".$idrand."'");
mysql_query($delete) or die(mysql_error());

}
?>

<?php
//met hulp van een script hier op deze site
function random($a)
    {
    $cijfers = '0123'; //beperkt houden anders neemt ie cijfers zoals 87 enz. 
    $shuffle = str_shuffle($tekens);
    $pass = substr($shuffle,0,$a);
    return $pass;
    }
$idrand = random(2); //hoeveel cijfers je hier wilt. Als je wilt dat ie alleen ids kiest van 1 t/m 9 moet je maar 1 tikken anders 2
$query="SELECT * FROM DD_players";
 
$result=mysql_query($query) or die(mysql_error());
 
if(mysql_num_rows($result) > 20)
{
 
$delete="DELETE FROM `DD_players` WHERE id='".$idrand."'");
mysql_query($delete) or die(mysql_error());
 
}
?>