random profiles on non-vb page

can you help me with this snippet of code please

PHP Code:

<?php

$randname="SELECT username, userid FROM user ORDER BY rand() LIMIT 1"; 

echo ("<a href=\"forums/member.php?s=&action=getinfo&userid=$randname\"><img src=\"img/v2-rand_prof.png\" alt=\"random profile\" width=\"292\" height=\"136\" border=\"0\" /></a>"); 

?>

when you click the image that that produces it's meant to send you to a random profile but instead of making the userid it gives me the query as the link

e.g. http://www.ebslive.com/forums/member...&userid=SELECT username, userid FROM user ORDER BY rand() LIMIT 1

[sabret00the]

ok i fixed this thanks to the wonders of phpmyadmin

but

PHP Code:

     $randprof = $DB_site->query_first("SELECT userid,usergroupid FROM user WHERE userid > 0 AND usergroupid <> 10 AND usergroupid <> 11 AND posts > 0 ORDER BY rand()");
              echo ("<a href=\"forums/member.php?s=&action=getinfo&userid=$randprof[userid]\" target=\"_blank\"><img src=\"img/v2-rand_prof.png\" alt=\"random profile\" width=\"292\" height=\"136\" border=\"0\" /></a>"); 


is there anyway to get this to change userid per click instead of per page load