glennnphp wrote:
thanks very much ---
i've tried to hire someone to help me "correct" a query i have running against another table to where it queries the xoops_avatars table instead. haven't had anyluck with someone who knows MySQL real well. i wonder if you'd be willing to look at the (short) script? i can pay a little.
can i PM it to you?
$random_member = mysql_fetch_assoc(mysql_query("SELECT uid, uname, user_avatar FROM xoops_users ORDER BY RAND() LIMIT 1"));
print "<p align='center'>";
print "<strong>Random member:</strong><br />";
print "<a href='userinfo.php?uid=$random_member[uid]'>$random_member[uname]</a><br />";
print "<img src='/uploads/$random_member[user_avatar]' alt='avatar' />";
print "</p>";