How can I optimize this

From: 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]"); } } }

« previous php.general (#146453) next »