Posted by Jim Hernandez on 11/05/05 00:17

I'm setting up a database for albums and I've decided to break the
tracklist down track by track in the table, i.e.,
albumkey (primary)
atitle
aartist
alabel
track1
track2
track3
track4... on through track 30.
I want to call the tracks via php form the database and put them into a
sidebar on a webpage. Say the db has room for 30 as mine does but the
album only has 14 tracks, how do I communicate to sql to pull until the
tracks are null and stop.

Thanks for any help or advice

[Back to original message]