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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
