Contribution table

Contribution table is project number 150498 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider ciprianvb
Budget:	$30-100
Created:	06/06/2007 at 16:18 EDT
Bidding Ends:	06/11/2007 at 16:18 EDT
Project Creator:	tompatterson   Buyer Rating: (11 reviews)
Description:	I have a php script accessing a mysql database and generating a report using mysql_fetch_array. After that, I am moving the results around in the script and performing some calculations before generating a report. Data in the mysql data table essentially consists of a number of contibutions, with the donor, the date and the amount all in separate field for each record. I am trying to get a listing of the contributions by each donor, with the amount for each month listed in a separate column for each month. The problem I am having is that while my script does this, it generates a separate line for the donor for each month there is a contribution. Thus, if there are three contributions in three separate months, I end up with three lines for that donor. I would like a fix for this problem. Additionally, I am using just one date for each month such as 2007-01-31, but would like to have the script be able to combine amounts if there were more than one date for a donor in an amount. Attached is a screen shot of the result I am currently getting, which shows the problem, as well as the script I am currently using. I have a mysql dump which can be sent if needed. Additional files submitted: Screen01.JPG contributionList3.php
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	2
Average bid:	$ 33