在单个查询中插入具有一个ID的多个记录

Question

Hello i want insert data into 2 different tables.

First table 'Events:'

id,
name,
desc,
date

Second table 'Events_sub_cat:'

id,
event_id,
name,
desc,
date

I want to insert 2 different data in one query like:

INSERT INTO Events (name, desc, date) VALUES ('name', 'desc', 'date')
INSERT INTO Events_sub_cat (event_id, name, desc, date) VALUES (event_id, 'name', 'desc', 'date')

And i want get in the same query the ID of the even what i just inserted in table 'Events' to let know to another INSERT what is the 'event_id'

Answer 1

There you go a suggestion:

Insert records into two table at once

As said in the post, there's no way to insert without using mysql_insert_id()