A nice introduction.

See the user comments.

The answer.

http://stackoverflow.com/questions/10594140/select-multiple-columns-from-a-row-that-are-based-on-same-related-table

Also this,

http://stackoverflow.com/questions/9114781/join-multiple-columns-from-one-table-to-single-column-from-another-table

A useful discussion about dealing with concurrent user conflicts in mySQL database.

A nice windows batch file.

The rules of the road for INPUT date information.

Here is a nice article on a tough subject.

A little tutorial on the subject will come in handy.

http://php.net/manual/en/function.mysql-insert-id.php