Hi Guys,
Here is my script:
<?
$link = mysql_connect('localhost', 'username', 'password');
mysql_select_db('typhoon_ent');
$query = "SELECT band_id, name FROM band";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
echo "<a href=\"http://localhost/band.php?id={$row['band_id']}\"><font color=\"#ff9900\">{$row['name']}</font></a> > <a href=\"http://localhost/album.php?id={$row['album_id']}\"><font color=\"#000000\">{$row['track_title']}</font></a><br>\n";
}
?>
What i need to know is how to query the database inorder to retrieve the relevent data from the album table. As you can see i can successfully get the data out of the band table.
Cheers,
andrea
