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:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] 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

Reply via email to