mysql_insert_id();

[djdaz]

Is it possible to get the id of the row and use that id in the same query?

IE
query will get a unique id number when its inserted via auto_increment. I need to use that same value on the same peice of data.

You get me?

Thanks in advance

[devinemke]

what does your query look like? are you trying to do multiple INSERTS/UPDATES within a single query?

[Drakla]

It's not going to happen, not in one query. You might want to look at LAST_INSERT_ID() and the tricks you can do with it at

http://dev.mysql.com/doc/mysql/en/getting-unique-id.html And
http://dev.mysql.com/doc/mysql/en/mysql-insert-id.html