[RESOLVED] retrieve multiple insert id's?

[leatherback]

Hi All,

I am building a site-indexing system to build an advanced search tool.
Part of this is create a personal index on my pages. I retrieve all the words from the content, description, keywords and title, merge them into an array with unique words and verify against an array with existing words. So far so good.

Now.. When I insert the new words (Wors not before indexed) I want to do this in a single query (insert into table (col1,col2) values ((,),(,),(,) etc).
Is it possible to do this, and at the same time retrieve the mysql_insert_id for all the inserted values? Or do I really have to
- Insert one word at a time
or
- Do some clever math between the last old ID and the last newly inserted ID?

Obvioulsy, I need these ID's again to create page-to-word links.

Any suggestions?

[Roger_Ramjet]

No way to do this with inset id, not that I've heard of. Instead of the 'clever maths' you should just query for the new data with it's id.

[leatherback]

'Alas! It is as I feared then!'

Cheers!