mamali-mohammad
پنج شنبه 12 دی 1392, 16:15 عصر
سلام
این کد رو چطوری بهینه کنم که سرعت پردازش بیشتر بشه :
$sql1 = mysql_query("SELECT * FROM `table` WHERE `active`='1' GROUP BY `title` ORDER BY `id` ASC");
while ($row = mysql_fetch_array($sql1)){
$title = $row["title"];
$sql2 = mysql_query("SELECT * FROM `table` WHERE `active`='1' AND `title`='$title' GROUP BY `title` ORDER BY `id` DESC");
while ($row2 = mysql_fetch_array($sql2)){
$sql3 = mysql_query("SELECT * FROM `table` WHERE `active`='1' AND `title`='$title' GROUP BY `name` ORDER BY `id` DESC");
while ($row3 = mysql_fetch_array($sql3)){
echo $row3["name"];
}
}
}
ممنون
این کد رو چطوری بهینه کنم که سرعت پردازش بیشتر بشه :
$sql1 = mysql_query("SELECT * FROM `table` WHERE `active`='1' GROUP BY `title` ORDER BY `id` ASC");
while ($row = mysql_fetch_array($sql1)){
$title = $row["title"];
$sql2 = mysql_query("SELECT * FROM `table` WHERE `active`='1' AND `title`='$title' GROUP BY `title` ORDER BY `id` DESC");
while ($row2 = mysql_fetch_array($sql2)){
$sql3 = mysql_query("SELECT * FROM `table` WHERE `active`='1' AND `title`='$title' GROUP BY `name` ORDER BY `id` DESC");
while ($row3 = mysql_fetch_array($sql3)){
echo $row3["name"];
}
}
}
ممنون