Text into a url

Hi I am havening a problem retrieving url from a mysql database. I have the url's stored as text and am using the following code to retrieve them $query = "SELECT name,url FROM clubs WHERE url>'' ORDER BY name"; $result = @mysql_query($query) or die ("Query failed"); if (mysql_num_rows($result) == 0) { print "No Club Links Found."; } else { while ($row = mysql_fetch_assoc($result)) { print $row["name"] . "<A HREF= ".$row['url'].">"; This seems to work except the url refers to the previous name on the list produced with the first name as a blank url. Can anybody help Thanks