Show number of new members who have signed up

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? 

It looks like it's aacounts to me, unless I'm missing something? :/ (screeshot attached)

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 />