blurring out, help need to get in the right direction please
Posted: Wed Sep 25, 2002 3:09 pm
I'm deep ashamed, but I'm totally blurring out the last two days on this problem. I have lost track on where and how to start, But I'm sure there must be codesnippets to help me on this.
The case.
I do have a mysql table that contains the following:
name varchar(64)
type varchar(16)
siblings (blob)
the type field can contain : CONTAINER PLATFORM COMPONENT
The sibblings is a text blob that contains a : seperated array of names like:
name1:name2:name3:name4
I now have a given name as first entry to get to the following:
I need to generate a table as the following:
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>test</title>
</head>
<body>
<table BORDER>
<tr>
<td rowspan=5>container1</td>
<td rowspan=3>container2</td>
<td rowspan=2>container3</td>
<td>platform</td>
</tr>
<tr>
<td>container4</td>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td rowspan=2>container5</td>
<td>platform</td>
</tr>
<tr>
<td>container6</td>
<td>platform</td>
</tr>
<tr>
<td rowspan=5>container7</td>
<td>platform</td>
</tr>
<tr>
<td rowspan=3>container8</td>
<td rowspan=2>container9</td>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
</table>
</body>
</html>
In the above table the container and platform names should be displayed.
So it should look like a node tree, where Containers are the nodes. and platforms are the trees.
The sibblings entry contains names that are also entries in that database.
so the namelist could consist of containername:containername:platformname:platformname for that entry.
Can anybody please give me a start on this ???
Thanx very much
The case.
I do have a mysql table that contains the following:
name varchar(64)
type varchar(16)
siblings (blob)
the type field can contain : CONTAINER PLATFORM COMPONENT
The sibblings is a text blob that contains a : seperated array of names like:
name1:name2:name3:name4
I now have a given name as first entry to get to the following:
I need to generate a table as the following:
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<title>test</title>
</head>
<body>
<table BORDER>
<tr>
<td rowspan=5>container1</td>
<td rowspan=3>container2</td>
<td rowspan=2>container3</td>
<td>platform</td>
</tr>
<tr>
<td>container4</td>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td rowspan=2>container5</td>
<td>platform</td>
</tr>
<tr>
<td>container6</td>
<td>platform</td>
</tr>
<tr>
<td rowspan=5>container7</td>
<td>platform</td>
</tr>
<tr>
<td rowspan=3>container8</td>
<td rowspan=2>container9</td>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
<tr>
<td>platform</td>
</tr>
</table>
</body>
</html>
In the above table the container and platform names should be displayed.
So it should look like a node tree, where Containers are the nodes. and platforms are the trees.
The sibblings entry contains names that are also entries in that database.
so the namelist could consist of containername:containername:platformname:platformname for that entry.
Can anybody please give me a start on this ???
Thanx very much