Optimise two mysql queries to one query
| From: | dr. zoidberg | Date: | Tue, 16 Mar 2004 22:12:24 +0000 |
| Subject: | Optimise two mysql queries to one query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-180612@lists.php.net to get a copy of this message | ||
Hello,
$a = mysql_query("Select a,b FROM t WHERE category=1")
while($a) {
$x = $a[a];
//some echo
//another query
$b = mysql_query("Select * FROM t WHERE subcategory=$x")
while ($b) {
//some echo
}
}
Point is that I have menus, parents with childes (childes are not
parents) and I want to display them using only one query.
- Parent 1
-- Child 1
-- Child 2
- Patent 2
-- Child 3
Child have subid that is parent id.
TNX
--
Please do not CC me.