Array
(
    [0] => Warning
    [1] => Undefined array key "language"
    [2] => /home/whmcsdev/public_repo/wbteampro.major-release/installation/modules/addons/wbteampro/initialize.php
    [3] => 282
)

Array
(
    [0] => Warning
    [1] => Undefined property: stdClass::$state
    [2] => /home/whmcsdev/public_repo/wbavatax.master/installation/modules/addons/wbavatax/hooks.php
    [3] => 942
)

Array
(
    [0] => Deprecated
    [1] => htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated
    [2] => /home/whmcsdev/public_repo/wbavatax.master/installation/modules/addons/wbavatax/hooks.php
    [3] => 279
)
Using GROUP_CONCAT to simplify your life - Knowledgebase - WHMCS Dev

  Categories

Business Consulting
2
Microsoft Windows Environment
15
Search Optimization
2
Software Documentation
37
Web Design & Development
22
Web Site Hosting
38

  Categories

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket
Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com

Using GROUP_CONCAT to simplify your life Print

  • 2
The GROUP_CONCAT function returns a comma separated list of all non-null values that were found in the query.  This is extremely useful when you want to pull a sub-set of related information during within a query, for example:

SELECT `user`.*
  , (SELECT GROUP_CONCAT(`usergroup_id`) FROM `usergroup_xref` WHERE `usergroup_xref`.`user_id` = `user`.`id`) AS `usergroup_ids`
FROM `users` AS `user`

In the above example you could retrieve all of the users group ids along with the user row within a single query.

Was this answer helpful?

Related Articles

Adding Google Maps to your Web Page Google Provides some amazing tools for bringing life to your website. One of them is the... Building MySQL Procedure Calls With the introduction of MySQL 5 comes a power that was before now were only available in more... Military Alphabet Converter Tool We need to use standards, and learning the NATO Military Alphabet is something that can make... Javascript Code Unpacker & Beautifier We searched and couldn't find a script that would unpack and beautify Javascript in one action,... Simple HTML Dom Parser for PHP Need an HTML Dom parser - checkout this great little class. A simple PHP HTML DOM parser written...
« Back

Powered by WHMCompleteSolution

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket