[GENERAL] Building dynamic contents from database

Hi, My problem is rather complex. I will try to explain it clearly (I hope !) Sorry for my poor english. I'm tracking change of state for entities (something than can be monitored.) The set of states are limited (state1 to state5.) A table is storing the current state for each entities, and an

Re: [GENERAL] Building dynamic contents from database

> name | state | from_date | to_date > > foo | state2 | | > foo | state1 | | > bar | state4 | | > ... > foo | state3 | | I would consider using only 1 table, where a NULL to_date indicates the current state, and you have a compound inde

[GENERAL] Building dynamic contents from database

Hi, My problem is rather complex. I will try to explain it clearly (I hope !) Sorry for my poor english. I'm tracking change of state for entities (something than can be monitored.) The set of states are limited (state1 to state5.) A table is storing the current state for each entities, and an