while ($row= mysql_fetch_array($result)) //retrieve a row and store in echo "<A HREF= ".$row['UrlColumnName'].">"; That's how I'd do it. <>< Ryan -----Original Message----- From: G [mailto:the_game_is_never_over@yahoo.co.uk] Sent: Monday, February 17, 2003 8:16 PM To: php-db@lists.php.net Subject: mysql +php Hi I was wonder if any knows how 2 display sound clips held in a mysql database using a php page ? I have stored the url’s of the clips in mysql database and I belive I need some like to (below) to display them but its not quite working. while ($row= mysql_fetch_row($result)) //retrieve a row and store in array $row { for($i=0; $i<mysql_num_fields($result);$i++) // echo ("<A HREF= "$row[$i]">"); // any ideas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php