[RESOLVED] foreign key ID

[cbesh2]

I'm fairly new to databases and am trying to understand how to do the following:

I have a form that enters a person's contact information when they attend a meeting (name, address, phone number, etc.). What I need is for the person's ID number (auto incremented) to be duplicated in my attendance table as a foreign key with the current date. How do I do this? How I get the person_ID to enter in both the people table and the attendance table?

Below is how my tables are set up:

PEOPLE - person_ID, name, address
DATE - date_ID, date
ATTENDANCE - person_ID (fk), date_ID (fk)

I appreciate your assistance. And thanks in advance.

[bogu]

Try this:
Php version: mysql_insert_id
OR

Mysql version wrote:

SHOW TABLE STATUS LIKE table_name

[cbesh2]

Great. Thank you so much for pointing me in the right direction. I'll have to do a little tweaking but I'm sure that will do the trick.