Print once? Help!

Anon

I pull out a list of documents from a mysql database, including the Section Name and Document Title. I want to organize these Documents by Section so that it prints out like:

Section
<ul>
<li>Document
<li>Document
<li>Document
</ul>

What I have so far is:
<?
/ fetch documents /
$query = "select DocumentName,SectionTitle from tbDocument order by SectionTitle";
$mysql_result = mysql_query($query, $mysql_link);
while($Documents = mysql_fetch_object($mysql_result)){
$DocumentName = stripslashes($Documents->DocumentName);
$SectionTitle = stripslashes($Documents->SectionTitle);
print "$SectionTitle\n";
print "<ul>\n";
print "<li>$DocumentName\n";
}
?>

This prints out like:

Section
<ul>
<li>Document
</ul>
Section
<ul>
<li>Document
</ul>
Section
<ul>
<li>Document
</ul>

How do I get it to print out the SectionTitle only ONCE?

Thanks!

Anon

Let's try this again... (Sorry about the html)

I pull out a list of documents from a mysql database, including the Section Name and Document Title. I want to organize these Documents by Section so that it prints out like:

Section
<ul>
<li>Document
<li>Document
<li>Document
</ul>

What I have so far is:
<?
/ fetch documents /
$query = "select DocumentName,SectionTitle from tbDocument order by SectionTitle";
$mysql_result = mysql_query($query, $mysql_link);
while($Documents = mysql_fetch_object($mysql_result)){
$DocumentName = stripslashes($Documents->DocumentName);
$SectionTitle = stripslashes($Documents->SectionTitle);
print "$SectionTitle\n";
print "[ul]\n";
print "[li]$DocumentName\n";
print "[/ul]\n";

}
?>

This prints out like:

Section
<ul>
<li>Document
</ul>
Section
<ul>
<li>Document
</ul>
Section
<ul>
<li>Document
</ul>

How do I get it to print out the SectionTitle only ONCE?

Thanks!

arnihr

try making < > > and < or something, so we can see the code 🙂

steved

Put something like this inside your while loop:

// Build $SectionTitle and $DocumentName
$DocumentName = stripslashes($Documents->DocumentName);
$SectionTitle = stripslashes($Documents->SectionTitle);

// Print 1st time, or if it is a new Section
if ($OldTitle <> $SectionTitle)
echo "$SectionTitle\n";

echo "$DocumentName";

// Save the current section title
$OldTitle = $SectionTitle;