Add hyperlinks to db-derived text

Hello,

I’ve gotten a lot of good tips from kirupa so here goes:

I am working on an mp3 player that pulls song titles from a database, using php and MXPRO2004.

I am able to display the song titles in a scrolling pane that contains a duplicating text box.

I would like to learn how to make a link for each song that would load an mp3 into Flash and play it, depending on the song title that is clicked.

The songs would be named 1.mp3, 2.mp3 etc, and would be kept in a specific folder. This folder would be based upon the album’s catalog number ( /audio/mp3/catalog_id/1.mp3 ). The catalog_id would be loaded from the page url and inserted into the link. The catalog_id would be a number, like 6528.

The mp3 file names (1.mp3 etc) would then append themselves to the link for the corresponding title.

Can someone point out a thread that talks about this or give me a few hints? Thanks alot!

The code that I have so far, which loads the titles::

myLoad = new LoadVars();
myLoad.path = this;
//this is the group’s name::
myLoad.musical_group_id = _root.musical_group_id;
//this is the album name::
myLoad.catalog_id = _root.catalog_id;

myLoad.onLoad = function(success)
{
if (success) {
this.path.pane_sp.boundingBox_mc._visible = false;
this.path.pane_sp.setScrollContent(“emptyClip”);
var mc = this.path.pane_sp.getScrollContent();
for (var i = 0; i < Number(this.totals); i++) {
var item = new Object();
item.title = this[“title” + i];
item._y = i * 25;
mc.attachMovie(“singleRecord”, “record” + i, i, item);
}
this.path.pane_sp.refreshPane();
} else {
trace(“PHP PAGE NOT FOUND”);
}
};
myLoad.SendAndLoad(“flash_songs.php”, myLoad, “GET”);