This query replace companyname with firstname and lastname of customer, when companyname is not yet defined:

UPDATE `tblclients` SET `companyname` = CONCAT(firstname, ' ', lastname) WHERE `companyname` = ''


This query calculates the current credit of the customer with id=123, making the sum of every single credit transaction 

SELECT sum(amount) FROM `tblcredit` WHERE clientid=123


This query replace companyname with firstname and lastname of customer, when companyname is defined as "n/a":


UPDATE `tblclients` SET `companyname` = CONCAT(firstname, ' ', lastname) WHERE `companyname` = 'n/a'

Found this article interesting?
Subscribe to DomainRegister´s newsletter!

You can unsubscribe at any time by simply clicking the link in the footer of our emails. For information about our privacy practices, please visit our website.

We use Mailchimp as our marketing platform. By clicking below to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing. Learn more about Mailchimp s privacy practices here.

  • WHMCS
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

 How to add a favicon in WHMCS

To add a favicon to your WHMCS install: copy your favicon (es. myfavicon.ico) in WHMCS folder...

 How to comment in template (.tpl) files

If you need to insert a comment in a .tpl file, or comment a block of code to disable it, you...

 How to insert a Youtube video in WHMCS knowledgebase article

To insert a YouTube video in an article of the WHMCS knowledge base, you need to insert following...

 How to disable a customer to pay invoices partly with credit balance

in WHMCS if a customer has not enough credit balance for full payment of an invoice, WHMCS allows...

 How to add a cookie bar to WHMCS

In order to add a cookie bar to your own installation of WHMCS: copy somewhere on your WHMCS...