[sabret00the]

urghh if it's in the table you just said then it's as simple as

phpinclude_start

PHP Code:

$latest_subscription = $DB_site->query_first("SELECT subscirptionlog.subsciptionid, user.username, subscirptionlog.userid FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscirptionlog.userid) ORDER BY subsciptionlog.subscriptionid DESC LIMIT 1"); 


then just put

<a href="member.php?$session[sessionurl]u=$latest_subscription[userid]>$latest_subscription[username]</a> is the latest subscriber at $vboptions[bbtitle].

hope it helps as i never read your think completely.