tomtimms Posted July 29, 2010 Share Posted July 29, 2010 I have a query that fetches all the dates in a date range then displays them in a Date:HH:MM;SS format. However when displayed sometimes there are missing Hours as I don't have data for them and I would like to display it. So right now I have something like this. Date Column: Revenue_Column: 07/29/2010 00:00:00 $250.00 07/29/2010 01:00:00 $150.00 07/29/2010 03:00:00 $350.00 07/29/2010 04:00:00 $450.00 As you can see 02:00:00 is missing, how can I use php or possibly mysql to fill in that gap? I have tried creating an hours table and joining them and grouping by date however that doesn't seem to work. Any ideas? Quote Link to comment Share on other sites More sharing options...
Jessica Posted July 29, 2010 Share Posted July 29, 2010 We'd need to see some of your code. One way to do it would be to before you print out the next row, check if the difference between that and the last is over one hour. If it is, do a while() to create $0 rows for each hour missing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.