Show number of new members who have signed up
15 posts by 3 authors in: Forums > CMS Builder
Last Post: April 15, 2016 (RSS)
It's giving me the following error. I've tried quite a few things and can't fix it:
April: mysql_count() MySQL Error: Table 'mysite_cms.cms_aaccounts' doesn't exist - in test_admin.php on line 42 by mysql_count()
By Damon - April 15, 2016
Hi,
The reason you are getting this error:
April: mysql_count() MySQL Error: Table 'mysite_cms.cms_aaccounts' doesn't exist - in test_admin.php on line 42 by mysql_count()
is because there isn't a MySQL table named aaccounts.
Log into CMS Builder (test_admin.php) and go to Admin > Section Editors. Here you will ll see all the Section Editor names as well as MySQL Table names.
What is the MySQL Table name for your accounts?
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
It looks like it's aacounts to me, unless I'm missing something? :/ (screeshot attached)
By Damon - April 15, 2016
I see the issue. I was a typo, I spelled aaccounts with two c's.
Try this code with only one c:
Total Signups for: <br />
April: <?php echo mysql_count('aacounts',"createdDate BETWEEN '2016-4-1' AND '2016-4-30'"); ?><br />
March: <?php echo mysql_count('aacounts',"createdDate BETWEEN '2016-3-1' AND '2016-3-31'"); ?><br />
February: <?php echo mysql_count('aacounts',"createdDate BETWEEN '2016-2-1' AND '2016-2-29'"); ?><br />
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Oh it as so simple, how annoying. Works perfectly now. Thanks :D