Просмотр поста

По оптимизации идейку подкину
возьму файл scan_dir.php

$req = mysql_query("SELECT `id` FROM `down_files` WHERE `refid` = '" . $result['id'] . "'");
while ($res = mysql_fetch_assoc($req)) {
    mysql_query("DELETE FROM `down_comms` WHERE `refid`='" . $res['id'] . "'");
    mysql_query("DELETE FROM `down_more` WHERE `refid` = '" . $res['id'] . "'");
}
//можно убрать вложенные запросы
$req = mysql_query("SELECT `id` FROM `down_files` WHERE `refid` = '" . $result['id'] . "'");
$ar = array();
while ($res = mysql_fetch_assoc($req)) {
    $ar = $res['id'];
}
$id_res = implode(',', $ar);
mysql_query("DELETE FROM `down_comms` WHERE `refid` IN (" . $id_res . ")");
mysql_query("DELETE FROM `down_more` WHERE `refid` IN (" . $id_res . ")");