How can I optimize this
| From: | Simon | Date: | Mon, 05 May 2003 21:15:36 +0000 |
| Subject: | How can I optimize this | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-146453@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to make my code run faster. I have table navigation with fields
id, sid, and title. Code looks like this:
I'd like to replace nested while's if possible.
TNX
$result = mysql_query("SELECT id,title FROM text where sid=0 order by id",
$db);
while ($myrow = mysql_fetch_array($result)) {
$f =$myrow[id];
$myrow["id"] = $tree->add_folder ($root, addslashes($myrow["title"]),
"/cms/text_edit/text_edit.php?a=$myrow[id]");
$resulta = mysql_query("SELECT id,title FROM text where sid='$f' order by
id", $db);
while ($myrowa = mysql_fetch_array($resulta)) {
$g =$myrowa[id];
$myrowa["id"] = $tree->add_folder ($myrow["id"],
addslashes($myrowa["title"]), "/cms/text_edit/text_edit.php?a=$myrowa[id]");
$resultb = mysql_query("SELECT id,title FROM text where sid='$g' order by
id", $db);
while ($myrowb = mysql_fetch_array($resultb)) {
$tree->add_document ($myrowa["id"], addslashes($myrowb["title"]),
"/cms/text_edit/text_edit.php?a=$myrowb[id]");
}
}
}