MySQL database design / PHP display

Budget $15 USD / hour
Bids 1
Average Bid $15

I have SQL data I want to insert into a database then analyse and display in a webpage

I would prefer to set up a relationship before sending over the full spec.

The first problem to fix is as follows:
I have an mySQL table listing prices and status' of properties advertised for sale
The price can go up and down, the status can change too.
I have a collection_date field, the records are generally added once per day.

I want to create a report or table summarising the changes in status and price (remembering that the price could be the same on two or more different dates - It's important that the result is a summary of each change in status)
e.g.
Source:

Collection_Date, Property_ID, Price, Status, Description ...
01/03/2013 09:00, XX123, 699000, ForSale,
02/03/2013 12:01, XX123, 699000, ForSale,
03/03/2013 09:05, XX123, 699000, ForSale,
02/07/2013 09:23, XX123, 710000, ForSale,
09/07/2013 09:23, XX123, 710000, ForSale,
21/07/2013 09:23, XX123, 710000, ForSale,
28/07/2013 09:23, XX123, 710000, ForSale,
05/08/2013 08:54, XX123, 699000, ForSale,
06/09/2013 09:02, XX123, 650000, SOLD

Result:
Source:

Collection_Date, Property_ID, Price, Status, Description ...
01/03/2013 09:00, XX123, 699000, ForSale,
03/03/2013 09:05, XX123, 699000, ForSale,
28/07/2013 09:23, XX123, 710000, ForSale,
05/08/2013 08:54, XX123, 699000, ForSale,
06/09/2013 09:02, XX123, 650000, SOLD

NOTE: the date is the date of the change. I don't know whether it's best to show the first record or to have a from and to datetime ?

Further Background:
I've kept the example pretty simple. I'll explain the full detail if we decide to do the whole project together.

Post a Project Like This

This project was awarded to

ddellav

Hire in confidence! He went above and beyond to give me everything I needed and even anticipated a few things he predicted I would need and already took care of them. And then he spent the time needed to educate me about what he did on the back end of the website. I will definitely be asking him to do future work.
About the Freelancer
ddellav Profile Picture

I've been programming for the past 15 years. I'm experienced in PHP, Perl, SQL, Bash, as well as C#.net. Currently I am focusing mostly on LAMP (Linux Apache MySQL & PHP) development and Linux Administration. I'm natively from South Florida, but currently live in North Carolina.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • ddellav Profile Picture

    ddellav

    Snow Camp,  United States

    I've been programming for the past 15 years. I'm experienced in PHP, Perl, SQL, Bash, as well as C#.net. Currently I am focusing mostly on LAMP (Linux Apache MySQL & PHP) development and Linux Administration. I'm natively from South Florida, but currently live in North Carolina.

    PHP, Perl, Javascript, and XML