$ids = mysql_query("SELECT `idvol` FROM `rus` ORDER BY `reyting` DESC LIMIT 2");
$row = mysql_fetch_array($ids);
$i=$row; // $i=$row['idvol']; - тогда ваще ниче не удаляет
if($i) {
$sql = 'DELETE FROM `rus` WHERE `idvol` NOT IN('.implode(', ', $i).')';
mysql_query($sql);
}
$ids = mysql_query("SELECT `idvol` FROM `rus` ORDER BY `reyting` DESC LIMIT 2");
while ($row = mysql_fetch_assoc($ids)) {
$i=$row;
if($i) {
$sql = 'DELETE FROM `rus` WHERE `idvol` NOT IN('.implode(', ', $i).')';
mysql_query($sql);
}
}
$ids = mysql_query("SELECT `idvol` FROM `rus` ORDER BY `reyting` DESC LIMIT 2");
while ($row = mysql_fetch_assoc($ids)) {
$i=$row['idvol'];
if($i) {
$sql = 'DELETE FROM `rus` WHERE `idvol` NOT IN('.implode(', ', $i).')';
mysql_query($sql);
}
}
$ids = mysql_query("SELECT `idvol` FROM `rus` ORDER BY `reyting` DESC LIMIT 2");
echo $ids;
// Resource id #23
Resource id #25
Resource id #27
Resource id #29
$liveid = mysql_query("SELECT idvol FROM `rus` ORDER BY `reyting` DESC LIMIT 20");
$query = "DELETE * FROM `rus` WHERE `idvol` NOT IN(...)";
mysql_query($query);
$res = mysql_query("SELECT idvol,reyting,name,vol,file,kto,rey,DATE_FORMAT(data,'%d %M %Y') AS data,orderdate FROM `rus` ORDER BY `reyting` DESC ");
while($row = mysql_fetch_array($res))
{
//вот запрос на выбор id а что он мне даст при удалении не могу понять.
$zaprosid=mysql_query("SELECT `idvol` FROM `rus`");
SELECT * FROM `users` WHERE `name`='$ww' ;