how to display first record for a day in php mysql by date for 1 week

mohitvats

actually i have 30 day data for employees in which employee have multiple record for 1 day. i want to display one record for every
day in php mysql. plz how do i select i am trying like

Expand|Select|Wrap|Line Numbers

 select * from Employee_entry where emp_id=2 and month=04 and year=2019 group by created_at;
 

but it showing all record for an employee for 30 day
but i need per day one record only.

Luuk

It's hard to give a correct answer to your question if we do not know your table definition.
Can you post the output of:

Expand|Select|Wrap|Line Numbers

show create table Employee_entry;

Also can you give a short example of 1 employee with some records, and the 'desired' output of your query?

how to display first record for a day in php mysql by date for 1 week

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ