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
SELECT p.a AS pa, p.b AS pb, c.a AS ca, c.b AS cb FROM t AS p LEFT JOIN t AS c ON c.subcategory = p.a WHERE p.category=1 ORDER BY p.category
This should give you what you want, but the two queries might be better speed wise....
-- paperCrane <Justin Patrin>
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
