Help
ma_anse's Profile
User Rating:
Find My Content
Display name history
Reputation: 0
Neutral
- Group:
- Members
- Active Posts:
- 20 (0.02 per day)
- Joined:
- 18-March 09
- Profile Views:
- 1,299
- Last Active:
May 07 2012 04:20 PM- Currently:
- Offline
My Information
- Member Title:
- Forum Newcomer
- Age:
- Age Unknown
- Birthday:
- Birthday Unknown
- Gender:
-
Not Telling
Contact Information
- E-mail:
- Click here to e-mail me
Users Experience
- Experience:
- Nothing
- Area of Expertise:
- Designer
Posts I've Made
-
In Topic: Querying database to export to excel
28 June 2011 - 07:37 AM
Thanks for the reply, however i think you have missed my point entirely, i have the required classes to create the spread sheet, and can create a spreadsheet no problem at all.. What i am struggling with is how to get the required data into the spreadsheet. I can get it to export a single weeks data but not multiple weeks and still sort it in the same way.
My spread sheet is to look something like this....
Name-------Total Hours-------Rate------Week1-------week2-----week3------week4------week5
john-------------8----------------4.92----------2---------------1-------------2--------------2--------------2
john-------------12---------------5.62----------3---------------2-------------3--------------2--------------2
sarah------------5----------------4.92----------1---------------1-------------1--------------1--------------1
i have the php to give me the required date ranges but im not sure how to structure the query and how to use the result set to create this.