Please note these forums are mostly a testing ground for my SMF work and I don't really use them otherwise.

Main Menu


Started by Guest, Dec 26, 2011, 09:41 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.


   //Let's prep the account to get some info...
      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();