[RESOLVED] Date help

[UKlee]

Hi again ok I have discovered another item I need some help /advice on.

I would like to get a count for every element filled on that day but however i am unsure how to make this query to the mysql db.

for example every thing filed on a monday or for each given day of the week may be better. table field is called date and is in datetime format Y-d-m H:i:s

how would i complete this query to get it to look for each even if i had to recreate the query for each day in order to show the result in a table.
PHP Version 4.3.11 being used

Select count (something) as total from database where ???

thanks for looking

[PHP_Novice2]

For one specific day:

SELECT count(something) AS total FROM `table` WHERE DATE_FORMAT(datetimefield, '%W') = 'Monday'

For each day of the week:

SELECT DATE_FORMAT(datetimefield, '%W') AS day, count(something) AS total FROM `table` GROUP BY day

Refer to the specifiers here .

[UKlee]

Thank you very much worked a treat. thanks for taking the time to reply a weath of information and friendly advice as always here.

kind regards

Lee