473,324 Members | 2,313 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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

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
  1. 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.
Apr 17 '19 #1
1 1205
Luuk
1,047 Expert 1GB
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
  1. 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?
Apr 21 '19 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: dr. zoidberg | last post by:
Hello, I'm pulling news titles from MySQL. How Can I display first record in bold (different than other ones). What is the best way to do that. Is there some 'magic' query or PHP function. ...
5
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test...
5
by: Hardy Wang | last post by:
Hi: Are there any algorithms I can use, that based on a given date and a culture code (different cultures may have different beginning of week), I can get first and last date of the current week?...
2
by: Benz | last post by:
Hello all, Can anyone please tell me how to find the first and last date of a week when the year and the week number is given? The week model followed is the ISO model: Monday is the 1st day of...
3
by: amerar | last post by:
Hi All, I want to convert a date...... I am given the Day of the Week, plus the Hour and Minute. I want to convert that into a YYYY-MM-DD HH:MI format so I can store it and sort it in...
0
by: hagar | last post by:
Hi all, I have a problem which I can not understand why this is happening! Debugging this I actually see that it grabs first record then when stepping through code to the line rsImportTo.AddNew...
1
by: orangetree666 | last post by:
Could someone help me please I have three tables: gallery gallery_images users I am joining data from the three tables the problem is that there are multiple records that appear in the...
6
by: zack | last post by:
This query has been driving me crazy, and would be grateful for a nudge in the right direction. Still pretty much a beginner using Access 2003, I just cannot figure the solution to the following in...
4
by: sweetpotatop | last post by:
Hi, I wonder if there is any function in VB or SQL that will return the date of first Monday of the Monday. Besides, is there are a way finding the numbers of Monday in a month? Thanks in...
4
by: mcupito | last post by:
I have a table that holds records of awards by award date. The awards are connected through an Employee table by EmployeeID as a foreign key. I am trying to find if any employee received their...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.