I absolutely need to add a separate table in my MYsql database, calling for each post.
I can't explain here but custom fields won't work for what I need.
So I will hack the WP core (I have no choice in fact and emergency is so important for the project... I will see for update problems later) to make new fields in the admin panel.
I have one but big question : how do I must write queries to call my new data(s) from my new table for a specific post ?
I have tried LEFT JOIN but it doesn't work.
In fact I think my new table structure isn't good. I have created a separate table called "moredates" and inside I have created 3 fields : "frozendate", "startdate", "enddate"...with a DATETIME configuration.
But Mysql says to me there isn't a "key" to my table, and how make clear the link between these new dates and each post ??? My query doesn't know to witch post belongs the new dates in the table ?
Is there a Mysql GOD in the neighborhood ?! Please help. I have made the functions to manage the dates (except the good queries) and the fields in the admin panel. I have only a big Mysql problem (where I am not good at all)...