Listing retrieved fields.

[lostcities]

My basic scenario is i am doind a discography for a band.

I have set u a table (disco_darling) for id, title, albumArtSrc, credits,

and have also set up a table (tracklisting_darling) for id, track01, track02, track03, track04 etc up to track20,

 

i have put information into the tables and displaying the information from disco_darling is sorted and works fine, but the tracklisting_darling data i want to display each field in a new <li> within an ordered list so:

<li>$row->track01</li>

<li>$row->track02</li> and so on.

 

And i am confused how to loop it to do this?

 

Any help would be most appreciated!

 

//Mark

[Illusion]

Wrong forum, its not a MySQL related question.Try it in PHP Code help forum.

[lostcities]

sorry didnt realise i was in this forum, have reposted in php forum so any mods that want to delete this thread go ahead!

 

//Wiggie