[Resolved] How to generate tree list

[warozzo]

How do I generate tree(?) list using control structure like 'while'?

This is what I like to do:

- List 1
   - Sublist 1
   - Sublist 2
   - Sublist 3
- List 2
   - Sublist 1
   - Sublist 2

Datas come from database (MySQL).

If I have code just like below:

$query = mysql_query("SELECT * FROM music");

I can generate the first list using the standard code below:

while ($res = mysql_fetch_array($query)) {
    echo "<li>$res[0]</li>";
}

But I can't think what I have to code with the sub-list.
I can't just do this:

while ($res = mysql_fetch_array($query)) {
    echo "<li>$res[0]"
	."<ul>"
	."<li>$res[1]"
	.</ul></li>";
}

because it'll have result like the list below:

- List 1
   - Sublist 1
- List 1
   - Sublist 2
- List 1
   - Sublist 3
- List 2
   - Sublist 1
- List 2
   - Sublist 2

which is I don't intent to.
Would someone help me?

[HalfaBee]

Where is the data for the sublist coming from?

HalfaBee

[warozzo]

Datas come from database (MySQL).

[eternalprophet]

while ($res = mysql_fetch_array($query)) {
echo "<li>$res[0]"
."<ul>"
."<li>$res[1]"
.</ul></li>";
}

standard list is like this
<ul>
<li></li>
<li></li>
</ol>
you are starting the list, putting ONE line and closing the list then closing the line. what you need is like this
<ol>
<li>subject1 here</li>
<ol>
//This starts another ordered list under the first line
<li>subject 1 subitem 1</li>
<li>subject 1 subitem 1</li>
</ol>
//that </ul> closed off the second list (subitems)
<li>subject1 here</li>
<ol>
//once again, subitems are the reason you start a new list
<li>subject 2 subitem1</li>
</ol>
//close subject 2 subitems
</ol>
//closes the overall list

This should give you this
1. subject1 here
a. subject 1 subitem 1
b. subject 1 subitem 2
2. subject 2 here
a. subject 2 subitem here

[warozzo]

No, using my code will work fine in every browser (I tested myself):

- List 1
  - sublist 1.1
  - sublist 1.2
- List 2
  - sublist 2.1
  - sublist 2.2

using this code:

<ul>
  <li>List 1
  <ul><li>sublist 1.1</li>
         <li>sublist 1.2</li>
  </ul>
  </li>
</ul>
<ul>
  <li>List 2
  <ul><li>sublist 2.1</li>
         <li>sublist 2.2</li>
  </ul>
  </li>
</ul>

and it's not the problem.
The problem is: how do generate tree-list like that from a MySQL database.

for instance, if I have data like table below:

+--------+--------------------+
| Name |       Email           |
+--------+--------------------+
| john   | [email][e-mail][/email]  |
+--------+--------------------+
| john   | [email][e-mail][/email]   |
+--------+--------------------+
| joan   | [email][e-mail][/email]  |
+--------+--------------------+
| joan   | [email][e-mail][/email] |
+--------+--------------------+

and I want to generate tree list like list below:

- john
  - [email][e-mail][/email]
  - [email][e-mail][/email]
- joan
  - [email][e-mail][/email]
  - [email][e-mail][/email]

how do I do this??

[eternalprophet]

My bad, you are right.

Select all the info, output the name, and for every email addy that matches the name you want it a subitem of the name right, then if its different close the subitems and start the next set with the new name?

name1
nameemail1
nameemail2
name2
nameemail1
nameemail2

I know the logic behind what you are doing but I don't know exactly how to code it without playing around and testing some. I'll post my code if I can get it working ok.

[HalfaBee]

You want something like this.

HalfaBee

<?
$result = mysql_query( 'select * from tablename order by name' ) or die( mysql_error() );
$name = "";
echo "<ul>";
while( ($row=mysql_fetch_assoc( $result ))!== FALSE )
{
    if( $row['name']!=$name )
    { 
        if( $name != "" )
            echo "</ul>\n";

    echo "<li>{$row['name']}</li><ul>\n";
    $name = $row['name'];
}
echo "<li>{$row['email']}</li>" ;
}
echo "</ul>";

?>

[warozzo]

Thanks, Halfabee.. it works!!! 🙂