News:

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

Main Menu

Paste-1324935696:v:use_geshi-1:v:type-php

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

Previous topic - Next topic

0 Members and 4 Guests are viewing this topic.

Guest

   //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;