Random members URL?

[roundhost]

I am currently using the following code to retreive a random members URL:

PHP Code:

$getnames = $DB_site->query("
                SELECT
                * FROM user
                ORDER BY rand()
                LIMIT 1
        ");

        while($geturl = $DB_site->fetch_array($getnames))
                {
                        if ($geturl[homepage] == null) {

                            $rnd_site = "<a href=\"http://www.roundhost.net\" target=\"blank\">http://www.roundhost.net</a>";

                        } else {

                            $rnd_site = "<a href=\"$geturl[homepage]\" target=\"blank\">$geturl[homepage]</a>";

                        }

                } 


However, i would like it so that it always gets a member that has a url, rather than changing it to point to roundhost if their url is empty...how could i do this? It should be easy but all my attempts have failed!

Thanks in advance,

RoundHost

[sabret00the]

change

PHP Code:

                SELECT
                * FROM user
                ORDER BY rand()
                LIMIT 1 


to

PHP Code:

                SELECT
                * FROM user
WHERE homepage != NULL
                ORDER BY rand()
                LIMIT 1 


[roundhost]

Thats one of the things i tried before, it just doesnt show anything! (thanks anyway)

[Andreas]

PHP Code:

 SELECT
                * FROM user
WHERE homepage != ''
                ORDER BY rand()
                LIMIT 1 


?

[roundhost]

Originally Posted by KirbyDE

PHP Code:

 SELECT
                * FROM user
WHERE homepage != ''
                ORDER BY rand()
                LIMIT 1 


?

Yes! It worked Wow, i must have NULL disabled for mysql or something strange Thanks a bunch

[Marco van Herwaarden]

HAve a look at the "NOT <=>" this is a NULL-save version of "NOT ="

If i remember right

[Dean C]

Btw, no point in selecting * when you just want the homepage. Go easy on your server and save it pulling all those extra un-needed columns