$query = "SELECT name,url FROM clubs WHERE url>'' ORDER BY name";
??
could it not be
$query = "SELECT name,url FROM clubs WHERE url !="" ORDER BY name";
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
