Codezwiz >> Forums >> General PHP Nuke Help >> Subscription member list- How to display subscribers

How can i list subscribers. I can list the subscribers but only the userid, how can i match the userid from the subscribers table to the nuke_users_username ?.

Thanks

Im not sure of the exact table fields but something like this will do it.

$result = $db->sql_query("SELECT s.subscription_id, u.user_id, u.username FROM ".$prefix."_subscriptions AS s LEFT JOIN ".$prefix."_users AS u ON s.subscription_id = u.user_id ORDER BY s.subscription_id DESC limit 0, 20");
while ($row = $db->sql_fetchrow($result)) {
$subscription_id = intval($row['subscription_id']);
$user_id = intval($row['user_id']);
$username = $row['username'];
echo "$username";

} //END SQL LOOP

Thanks very much for your help. i did some tweaking because as you said you were not sure if the tables were correct so I used the right ones and it's working great now

.

phpnuke themes , tutorials , modules , blocks [ Register or login to view links on this board. ]