MySQL database design / PHP display

Awarded

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.

Skills: SQL

See more: sql create table price, in design best price, database design prices, database design price, create an advertised, best webpage design, mysql database design, database design, database design sql, together mysql, database design php mysql report, database design record, sql database relationship, design simple sql, mysql pretty, create sql report, php display, analyse php, php mysql sql example, table report design, create report database php, php analyse, database project php, insert mysql table, mysql date field

Project ID: #5001668

1 freelancer is bidding on average $15 for this job

ddellav

Hired by the Employer

$15 USD / hour
(2 Reviews)
1.6