I'm trying to run two queries. The second one enters data into a second table...but needs the id (auto incremented) from the first insert query. Is there any solution for this?

Sorry for bad typing... broke my hand last night, hard to get used to one finger typing.

So to be clear,

You are running a query that adds a new record to your table, using an auto_incremeted ID

Then a second query that requires the ID from the first queries record.

Are you running them at the same time, or in order?

http://uk.php.net/mysql_insert_id

Would mysql_insert_id work? http://www.php.net/manual/en/function.mysql-insert-id.php

Thanks, I think that's exactly what I was looking for.