$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
}
}Poent is thet 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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
