Grab value from sql insert, php

I have a table with three feilds orderID (auto increment), custID, date I want to insert a new row into this table and at the same time find what the orderID is. Is there a way to set that value to a php variable?