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 figured it out kinda

PHP Code:

<?php
$randpro2 = "SELECT * FROM user WHERE userid > 0 AND usergroupid != 10 AND usergroupid != 11"; 
$randprof = rand(0,$numbermembers); 
echo ("<a href=\"forums/member.php?s=&action=getinfo&userid=$randpro2\"><img src=\"img/v2-rand_prof.png\" alt=\"random profile\" width=\"292\" height=\"136\" border=\"0\" /></a>");
?>

just need to get $randpro2 to echo the number of users instead of the users, can someone help?

[Dean C]

PHP Code:

$random = $DB_site->query_first("SELECT userid,usergroupid FROM user WHERE userid > 0 AND usergroupid <> 10 AND usergroupid <> 11 ORDER BY rand()");

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

[sabret00the]

thanks mist, it's greatly appreciated

[Dean C]

Your welcome It's always nice answering such simple questions from a place in learning where I was only 6months ago

[sabret00the]

i have an additional query mist, how would i edit the code so it only shows members with more > 0 posts?

[Dean C]

PHP Code:

 $random = $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=$random[userid]\"><img src=\"img/v2-rand_prof.png\" alt=\"random profile\" width=\"292\" height=\"136\" border=\"0\" /></a>"; 

[sabret00the]

i get this error

Fatal error: Call to a member function on a non-object in /home/ebslive/public_html/index.php on line 161

[Dean C]

And what is on that line?

[sabret00the]

$random = $DB_site->query_first("SELECT userid,usergroupid FROM user WHERE userid > 0 AND usergroupid <> 10 AND usergroupid <> 11 AND posts > 0 ORDER BY rand()");

is that line exactly