auto increment values

[searls03]

ok, how do I add an auto incremented value to another table at the same time the value is created. 

so I will do a query to insert into db, and it creates auto incremented value of 1, then I need this value to also be put into another table just as text.  how do I go about doing this?  I need this all in one query.

[Psycho]

I need this all in one query.

Why do you need it to be done in one query? Just do the insert into the first table, then get the id using mysql_insert_id(). Then do your Insert into the second table using that id.

 

[jcbones]

Or, you could use a trigger.