[Resolved] insert into two tables ????

[twcmad]

I am gunna kick myself if this is easy but this is what I need to be able to do.

On save insert template name into template Table.

In template is various cards with different properties.

insert the card properties into a card table with the templateId that was created in the first mysql statement.

How do you do this ?????????

template table

templateID PK
templateDescription

card table

cardId PK
templateID
property 1
property 2
property 3

On save from the screen (flash movie) I need to save the template details and then all the objects in the template to the card table using the templateId as the link when I need to do a lookup

Any suggestions ??????

Thanks

David

[mrhappiness]

[man]mysql_insert_id[/man] or

SELECT LAST_INSERT_ID()

[twcmad]

Now have very sore behind

Thank you very much

David