each entry in db has the columns ID,NAME,TEXT,LEVEL,DEPENDENT
level has a value of 1 or 2 depending if it's an item or a subitem
dependent has a reference to the id of the section it belongs to
Using dreamweaver I created two recordsets based on the level, they are called row_sections (only where level = 1) and row_subsections (only where level = 2)
here is the code I tried to use:
Code: Select all
<?php do { ?>
<p><a href="test.php?sec=<?php echo $row_sections['id'];?>"><?php echo $row_sections['name']; ?></a></p> //prints the section text
<?php do { ?>
<?php
if($row_subsections['dependent'] == $row_sections['id']) {
echo $row_subsections['name']."<br>"; //tries to print all subitems corresponding to the actual item
}
?>
<?php } while ($row_subsections = mysql_fetch_assoc($subsections)); ?>
<?php } while ($row_sections = mysql_fetch_assoc($sections)); ?>both section 1 and 2 should have two subitems.. where is the problem?section 1 title
subsection 1
subsection 2
section 2 title
edit: if I add the line
Code: Select all
<?php echo $row_sections['id']; ?>Code: Select all
<?php do{ ?>