Well there is one easy sollution (if I understand your qestion correctly)
What I think you want is an history of old properties and values..
so what to do? well create a "history" table that hold all these old values
and then the normal table only contains 1 value for each property..
So wheneve
* P.Agenbag
> So, how would the query string look that would only return ONE set of
> data for that specific property?
Use the LIMIT clause of the SELECT statement:
http://www.mysql.com/doc/S/E/SELECT.html >
In short: add "LIMIT 1" at the end of your query, and it will only return
one row.
>