Hosting&COLO

I know this thread is a few months old, but the discussion is exactly what I have been dealing with as of late. ehuk has a good point. Everything mentioned IS client-related would assist in Client Management. In fact, the term "Client Managment" is far too general, as it should be considered "Hosting Client Management". I don't think you'll find a Dentist managing their clients with WHMCS. I realize that only a minority of us here provide Colocation Services (for me its a good portion of my business), but Colocation IS a form of Hosting, and as such, should have the necessary tools and utilities to manage Colocation customers. -R

I'm a self-taught, weekend-warrior with PHP/MySQL that can generally handle basic queries, but I'm hoping that someone with some PHP/MySQL skills can assist me. I'm trying to display the query results of the Clients and Custom Client Fields table by customer, but I'm having problems. Here's my query... $query = "SELECT tblclients.id, tblclients.firstname, tblclients.lastname, tblclients.companyname, tblclients.status, tblcustomfieldsvalues.fieldid, tblcustomfieldsvalues.relid, tblcustomfieldsvalues.value FROM tblclients,tblcustomfieldsvalues WHERE tblclients.status='active' AND tblclients.id=tblcustomfieldsvalues.relid GROUP BY tblclients.id"; $result=mysql_query($query); Now, in order to display the results, I have this... while ($data = mysql_fetch_array($result)) { $id = $data["id"]; $firstname = $data["firstname"]; $lastname = $data["lastname"]; $companyname = $data["companyname"]; That part is easy, its trying to specify each "Value" from TBLCUSTOMFIELDSVALUES as "$value1", "$value2", etc... so I can display it in its own column based on the Customer ID. Each row has the following columns... ID Firstname Lastname Company Name Value1 Value2 Value3 If I was only trying to retrieve just 1 value from TBLCUSTOMFIELDSVALUES, I could filter that value in the query and get only that info, but because I'm retrieving multiple values, I'm running into issues. Any ideas how I can make this work? Can I (or should I) code this better/different? Your help is supremely appreciated. Thank you. -R

How hard would it be to make specific status info viewable by the Customer? Even better if the Customer has the ability to configure which ports to monitor and which email address would be used for notifications.

Sounds to me like there needs to be something like a Reseller Role, similar to what currently exists in most of the Hosting Control Panels. Resellers would be created as any other Customer, with a Reseller checkbox option added to define this Customer as a Reseller. A simple dropdown box option with names of the existing Resellers could be added to the customer profile that would allow the Main Admin to select the specific reseller the customer will appear. This would give the "Reseller" full access to WHMCS, but only to his/her customer base. To take this one step further, if we had the ability to "Brand" a reseller, it would also create the opportunity for us to offer a all-in-one, ready-to-go hosting business.