Several dates for one post ! Big project !

Hi,

I want to use WP for a scientific revue. It will manage events of the scientific community. So I need to had for posts the possibility of 3 dates more :

– the “frozen date” (the day of the event in the future)
– the “start date”
– the “end date” (the days of start and end for an event witch take several days)

So in the admin panel, for each post, you will be able to attribute these 3 dates to the post. And on the website, home functions will display or archive news of events by these dates.

I have no problem for writing the functions to dis)play or archive. My problem is that I have created a table in my MYsql calles “wp_home_moredates” with 3 fields :

– “frozendate”
– “startdate”
– “enddate”

but Mysql says to me there is no key define for my table … ???!?

And I don’t know how to write the query to select posts by “frozendate”, etc…

I try to do something out of the WP core. It would be easier if I have created the fields in “wp-posts” but when upgrade, it will crash all the machine… !

I have search in the forum but nothing (except on future date but it doesn’t match to my problem).

Can you all help me to elaborate something clean here about this problem ?

Is there a way to make the same thing more easier with extra fields ? (I have tried whithout success)

Please help me. It would be a great feature I believe to control as many dates by post as we want… isn’t it ?