//Let's prep the account to get some info...
$res2=mysql_query("
SELECT cx.id_member, cx.uname, cx.requestd, cx.nextbd, cx.cxreasons,
cx.intnotes, ls.start_time, a.payment_provider, a.ccFirst6, a.ccLast4
FROM ADMIN_cxrequests AS cx
LEFT JOIN z_log_subscribed AS ls ON (ls.id_member = cx.id_member)
INNER JOIN account AS a ON (ls.id_member = a.id_member)
WHERE cx.cxid='$cxid'
AND ls.id_member = cx.id_member
AND ls.id_subscribe = '1'
"); echo mysql_error();
list($id_member,$uname,$requestd,$nextbd,$cxreasons,$intnotes,
$mbrsince,$provider,$ccf6,$ccl4)=$res2;