Using single query add two records

[amit_patel]

Hello All,

I want to use one single query in which i want to insert record in one table and get it's id as Alias which i want to insert in other table.

using single query..

so how can i do this?

Thanks and reagard,
--Amit Patel

[leagal4ever]

Not sure if thise can be done in one query. I do stuff like thise:
//insert first info
$id = mysql_insert_id();// use this to get last auto increment value
// use $id