Extract rows from database in a particular order

[Waleed-KH]

Hey guys

If i have a database like this

 

How can I extract items so that after each item is extracted sub​​-items

So the output will be

 

		<ul>
			<li>
				<span>Item 1</span>
			</li>
			<li>
				<span>Item 2</span>
				<ul>
					<li>
						<span>Item 2-1</span>
						<ul>
							<li>
								<span>Item 2-1-1</span>
							</li>
							<li>
								<span>Item 2-1-2</span>
							</li>
						</ul>
					</li>
					<li>
						<span>Item 2-2</span>
						<ul>
							<li>
								<span>Item 2-2-1</span>
								<ul>
									<li>
										<span>Item 2-2-1-1</span>
									</li>
									<li>
										<span>Item 2-2-1-2</span>
									</li>
								</ul>
							</li>
						</ul>
					</li>
				</ul>
			</li>
			<li>
				<span>Item 3</span>
				<ul>
					<li>
						<span>Item 3-1</span>
						<ul>
							<li>
								<span>Item 3-1-1</span>
							</li>
						</ul>
					</li>
					<li>
						<span>Item 3-2</span>
					</li>
					<li>
						<span>Item 3-3</span>
					</li>
				</ul>
			</li>
		</ul>
 

Please answer and thank you

[computermax2328]

Can you reattach the photo of your database? The basic idea is to query the database, loop through the results and echo out the query results inside out the loop along with the HTML you want to output.

[Waleed-KH]

database :

[jazzman1]

Only one table - check this out.

 

You can google it - how to display hierarchy in php.