Multiple <ul> Lists PHP Loop

[Danny620]

Hi, I need help to create a list like this with data from a database im having trouble doing so i have a table called company with 5 fields (installer, assessor, provider, trainer, other) if for example installer in the filed list = 1 then add to list else dont and see if assessor needs added if = 1 add then close list and see if provider = 1 if it does'tn then ask next.

 

<ul>

<li>Item 1</li>

<li>Item 2</li>

</ul>

 

<ul>

<li>Item 3</li>

<li>Item 4</li>

</ul>

[dragon_sa]

Where are you having trouble?, show us the code you have tried so far with the problem