Witam, czy ktoś potrafi to zoptymalizować?
$em = mysql_query("SELECT * FROM emails GROUP BY email");
$i = 0;
while($r = mysql_fetch_array($em))
{
$i++;
if($i>500)
break;
$id = $r['id'];
$email = $r['email'];
$lang = $r['lang'];
$phone = $r['phone'];
$bw = $r['bw'];
$find = mysql_query("SELECT * FROM emails_all WHERE email='$email'");
if(($f = mysql_fetch_array($find)))
{
$lang1 = $f['lang'];
$phone1 = $f['phone'];
$bw1 = $r['bw'];
if($lang == "" || $phone == "" || $bw == "")
{
mysql_query("UPDATE INTO emails_all (id, email, lang, phone, bw) VALUES (null, '$email', '$lang', '$phone', '$bw')");
}
}
else
{
mysql_query("INSERT INTO emails_all(id, email, lang, phone, bw) VALUES (null, '$email', '$lang', '$phone', '$bw')");
}
mysql_query("DELETE FROM emails WHERE id = $id");
}
mysql_query("OPTIMIZE TABLE emails");
mysql_query("TRUNCATE emails");