rkatz0 Posted June 4, 2009 Share Posted June 4, 2009 Hi, Support keeps answering me like it is in the docs or very obvious but I simply do not see it. I want to modify the homepage.tpl in Admin to show the total amount for Unpaid Invoices. Support says I need "a custom {php} code block to select the data from the DB, format and then output for display." The query is elementary which they provided: SELECT SUM(total) FROM tblinvoices WHERE status='Unpaid' I suspect something goes inside {php} {/php} but I do not see any examples of it in the docs. I guess the variable needs to be created and formatted somewhere. Can anyone point to an example or doc about this? I searched "custom {php} code query" but many other things seemed to come up. Thank you in advance. 0 Quote Link to comment Share on other sites More sharing options...
rkatz0 Posted June 4, 2009 Author Share Posted June 4, 2009 nevermind, this was answered in http://forum.whmcs.com/showthread.php?t=20013 If anyone knows the variable (if there is one) for the currency symbol(s) that would be great, thanks. 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.