row reference and media player

[moog69]

Hi All, I am a Newbie so if I'm asking a stupid question I apologize.
Basically I have a Database with two text columns "title, audioFile". The title column is the title of a piece of music i.e. "Breathe". The audioFile column is the filename i.e. "Breathe_14.aiff". What I would like to happen is for the title field only to be displayed in a webpage. It should be a link to lanch a player with the appropriate audiofile i.e. click on the "Breathe" link launch a player with the "Breath_14.aiff" audio file playing.
Now I don't know if this is possible. So please let me know what you think.
Thanks for reading,
moog69

[bpat1434]

Basically:
-- Connect to mySQL
-- Run your query
-- Display what you want

<?php
$con = mysql_connect("localhost", "mysql_username", "mysql_password");
mysql_select_db("mysql_database", $con);

$query = "SELECT * FROM `table`ORDER BY id DESC";
$result = mysql_query($query);
while($r = mysql_fetch_array($result))
{
    echo '<b><a href="'.$r['filename'].'" alt="'.$r['title'].'">'.$r['title'].'</a></b><br>';
}

?>

~Brett

[moog69]

Thanks thats pretty much what I was looking for. Works Really well.
Cheers,
Moog69