naveendk.55 Posted November 22, 2011 Share Posted November 22, 2011 I am trying to get result and display them in a particular format. I’m a beginner and hope below discription is clear. Table Structure is like mentioned below: ID| Date | Report| Start time | End Time REPORT Attribute hold any of the three values(Productivity, Monitoring, Break). I want to display the output in below two formats between two selected dates from a form. a) DATE | Productivity | Monitoring | break| Start Time | End Time. The report field has the paramenters productivity, Monitoring and Break. If the value has productivity, then it should display in Productivity column, Monitoring value should be displaed in monitoring field. I’m using PHP and Mysql. b) DATE | Productivity | Monitoring | break| Start Time | End Time. Here, I want the optput same a above however,the Start time and End time should display the sum of time between the selected dates. Link to comment https://forums.phpfreaks.com/topic/251593-mysql-querie-help-for-a-beginner/ Share on other sites More sharing options...
Nodral Posted November 22, 2011 Share Posted November 22, 2011 What code have you got so far or do you want to pay someone to write the whole thing for you? Link to comment https://forums.phpfreaks.com/topic/251593-mysql-querie-help-for-a-beginner/#findComment-1290402 Share on other sites More sharing options...
naveendk.55 Posted November 22, 2011 Author Share Posted November 22, 2011 Hi I tried few things and was not able to solve it. Also just let me know how to implement such things. I'll be able to do that. All I need is the logic that I need to follow. Help help if I'll be able to do it with mySQL or not. If I need to format after retrieving the data?. This will be a big help. Thanks Link to comment https://forums.phpfreaks.com/topic/251593-mysql-querie-help-for-a-beginner/#findComment-1290480 Share on other sites More sharing options...
Pikachu2000 Posted November 22, 2011 Share Posted November 22, 2011 The purpose of this site is to help people with code they have written, not to provide a place for people to come get code written for them. Surely you can at least make an effort, and write some of this yourself, yes? Link to comment https://forums.phpfreaks.com/topic/251593-mysql-querie-help-for-a-beginner/#findComment-1290508 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.