Statistic

[Yatahonga]

Hi,

I would like to know how many new
- registered user
- images

I have BY Day.

I didn't find the good SQL request. Does anyone have do that ?

Thanks

Cyrille

[V@no]

if u know little bit PHP, then take a look at index.php, where the new images shows. It uses time limit. u can easily use same alghorithm to count how many images where added today, with little modifications same could be done for users.

[Yatahonga]

Yes of course in PHP, but
I am looking for something like
select * from user group by inscription_date

With a format(inscription_date, XXXX)

Else I can add a colum (date as String) which contain the date like 05/005/2003 and do the select on this news colum

Cyrille

[Yatahonga]

sorry,

select count(id) from user group by MyNewDateColum

Cyrille

[V@no]

well, try something like this:

Code: [Select]

$time = time() - 60 * 60 * 24 * 1;
$sql = "SELECT COUNT(user_id) AS new
FROM ".USERS_TABLE."
WHERE user_joindate >= ".$time;
$users = $site_db->query_firstrow($sql);
$sql = "SELECT COUNT(image_id) AS new
FROM ".IMAGES_TABLE." i
WHERE image_date >= ".$time;
$images = $site_db->query_firstrow($sql);
then u'll have new images in last 24 hours in $images['new'] and users in $users['new']

*havent test it though