mrprez Posted April 3, 2008 Share Posted April 3, 2008 Anyone who is good at doing joined queries? I need to get a list of all Active customer's email addresses who have a PP subscription. Anyone? John 0 Quote Link to comment Share on other sites More sharing options...
mrprez Posted April 4, 2008 Author Share Posted April 4, 2008 SELECT tblclients.email, tblclients.id FROM tblclients, tblhosting WHERE tblhosting.userid = tblclients.id AND tblhosting.domainstatus = "Active" AND tblhosting.paymentmethod = "paypal" The only problem with this is that this isn't necessarily their email address at PP! 0 Quote Link to comment Share on other sites More sharing options...
HiDef-Laws Posted April 9, 2008 Share Posted April 9, 2008 I wouldn't mind seeing the Paypal subscriber's primary email address underneath the Subscription number in a clients product screen. I presently hand-send Paypal account validation emails prior to setting up any client service. If this were captured by WHMCS I could easily automate the process and have the system send out this email and capture the response. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.