PHP and MySQL Query

[grungefreak]

I have a small discussion forum. There is a "threads" table in the db and a "topics" table in the db. When a user creates a thread, it is inserted into the "threads" table from the php script. But I want the primary key of that record to be inserted as a foreign key into the "Topics" table. I know this can be done through php but someone suggested that I can set the field in the database to automatically grab the pk of the last thread. Any ideas on how this would be done?

 

GF

[craygo]

mysql_insert_id()

 

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

 

This will grab the insert id from the last insert

 

Ray

[grungefreak]

mysql_insert_id()

 

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

 

This will grab the insert id from the last insert

 

Ray

 

Thanks Ray,

 

I know about that PHP function, I am wondering can this be done through the database itself?

 

GF