i wrote a recursive code but it isn't working, maybe someone can help

[sd1]

hi. this is my code:

i guess that i'm missing something but i can't figure out what is it.

function category_tree($parentID) {
	$resultSections = mysql_query("SELECT * FROM tblAdminsSections WHERE parentID='$parentID' ORDER BY 'showOrder'");
	#echo "<div dir=ltr>SELECT * FROM tblAdminsSections WHERE parentID='$parentID' ORDER BY 'showOrder' </div><br>";
	while ($rowSections = mysql_fetch_array($resultSections)) {
		if ($prevParentID != $rowSections[parentID]) {
			$fieldCount++;
		} 
		$startCount = "0";
		echo "
		<tr>";
		while ($startCount < $fieldCount) {
			echo "<td>&nbsp;</td>";
			$startCount++;
		}
		if ($rowSections[parentID] == 0) {
			$fieldCount = 0;
		} 

	echo "
		<td><input type=checkbox name=veirfy[]>$rowSections[title]</td>	
	</tr>
	";
	$parentID = $rowSections[id];
	$prevParentID = $rowSections[parentID];
	category_tree($parentID);
}
}

category_tree(0);

this is the structure of tblAdminsSections table:
id
title
pageName
showOrder
parentID
active
addDate

[mrhappiness]

sd1 wrote:

hi. this is my code:

i guess that i'm missing something but i can't figure out what is it.

That's a pity indeed

What is this fucntion intended to do?
What does it do?
What does it not do?
Why do you order by the string 'showOrder' which will be the same for every entry in your table?
Why don't you order bythe column showorder?
Why do you put the parent-ID into '? Is it not numeric?
Why oh Why...? 🙂

[sd1]

Hi mrhappiness
thanx for you help:

What is this fucntion intended to do?
this functinos intend to go over tblAdminsSections and display my categories tree hierarchicly.

What does it do?
when i run this function now i get the Zero level and the 1st sub-level okay, but it is not showing the next sub levels, they are shown in the first sub-level.

What does it not do?
it's not displaying the tree as it should be.

Why do you order by the string 'showOrder' which will be the same for every entry in your table?
the showOrder is not the same. every "sub category" have it's own show order hierarchicly

Why don't you order bythe column showorder?
good idea. i will do that.

Why do you put the parent-ID into '? Is it not numeric?
it is numeric, i'm simply used to use '

[mrhappiness]

try something like this:

function category_tree($parentID) {
  $result = '';
  $resultsections = mysql_query('SELECT * FROM tblAdminsSections WHERE parentID = '.$parentID.' ORDER BY showOrder');
  $count = mysql_num_rows($resultsections);
  if ($count == 0) {
  //no results
	  return $result;
  }
  //at least one result

  /start list
  $result = '<ul>';
  while ($row = mysql_fetch_assoc($resultsections)) {
    //start list item
    $result .= '<li>';
    //add entry's name
    $result. = $row['title'];
    //add entry's sub-elements
    $result .= category_tree($row['id']);
    //end list item
    $result .= '</li>';
  }

  //end list
  $result .= '</ul>';

  return $result;
}
echo category_tree(0);

maybe that helps

[sd1]

Hi again mrhappiness and tanks a lot.
now i can see all the tree, but it's in a list - and i need it in table mode with checkboxes.

do u or anyone have any other idea?

maybe you can explain to me what's wrong with my code?

[mrhappiness]

please post an example of the desired output

[phphp]

place a <input type="checkbox" name="'> tag at where u you want to
use css + li