Regarding representing and storing dates after 2037, I need to analyze this discussion further.
Situation: Updating 2 tables at the same time. The second table is keyed to the auto increment column of the first table. How do you get the auto increment value for the row you just entered?
This answers the question.
Jason Priem’s page about parsing human names in PHP.