Show admin customer signups by date?

[marcopolo]

I would like to modify the admin index page to display new customers by date/day (total count). I can not find any postings on this and thought it would be a nice piece of information to see on a daily basis.

For example last 5 days:

date: 40
date: 25
date: 6
date: 10
date: 2

[marcopolo]

Ok getting there...I think :)

I added this code to the admin index page:
$customers_daily = $db->Execute("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_date_account_created = ?????????");

The above ????? is where I'm stuck, trying to get it to display customers that signed up with today's date.

Can anybody finish the statment above?

I would like to modify the admin index page to display new customers by date/day (total count). I can not find any postings on this and thought it would be a nice piece of information to see on a daily basis.

For example last 5 days:

date: 40
date: 25
date: 6
date: 10
date: 2

[marcopolo]

Ok I'm try to add a new peice of info to the Admin index page, I would like to see a tally of new sign cusotmers for the day.

I added this code to the admin index page:
$customers_daily = $db->Execute("select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_date_account_created = ?????????");

The above ????? is where I'm stuck, trying to get it to display customers that created an account with today's date.

Can anybody finish the statment above?

[marcopolo]

I double posted this, sorry...I could not find the original one.

Still need help!

[Steven300]

This hasn't been tested but it should work.

$today = date("Y-m-d");

$sql_customers_daily_query="select count(*) as count from " . TABLE_CUSTOMERS_INFO . " where customers_info_date_account_created like '".$today."%'";

$customers_daily=$db->Execute($sql_customers_daily_query);

[marcopolo]

It worked perfect...thank you sir!

[marcopolo]

How would you format the below to represent the day before:
$yesterday = date("Y-m-d") - 1;


For example if I want to see total new customers for "yesterday"

[Steven300]

$yesterday = date("Y-m-d", time()-86400);

[marcopolo]

Thank you again, I appreciate your help!