Hey guys,
i just want to look in my database and get displayed how many images were uploaded by day.
My problem is counting the dates...
This is my query, which displays just all dates of images:
I think i should count the result of "LEFT(image_date,10)"...but i don't know how.
Does someone know the solution?
Regards,
Avast
i just want to look in my database and get displayed how many images were uploaded by day.
My problem is counting the dates...
This is my query, which displays just all dates of images:
Code:
SELECT LEFT(image_date, 10) FROM `chv_images` GROUP BY image_date
I think i should count the result of "LEFT(image_date,10)"...but i don't know how.
Does someone know the solution?
Regards,
Avast